Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “viragos” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

157 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
viragos114671(None) 
virago1046641virago_
viragoes1245231viragoes
imagos9117552_imagos
mirages102213532mirages
vibratos13217482vibratos
vireos94212452vir_eos
virgas1048882vir_gas
visages1138692visages
aerugos834923aerugos
airbags1036293airbag_s
averages1249183averages
bigos85020013bi__gos
bingos95514793bi_ngos
biramose1243933biramose
biramous1266073biramous
biros75325133bir__os
borages103917163borages
brags85625103_brag_s
bravos114711393_bravos
cargos94619183car_gos
crags85622573_crag_s
curaghs1334583curaghs
dagos76419443__dagos
dirams94413703dira_ms
dirges84915103dir_ges
dorados938203dorados
dragon838843_dragon
dragons938383_dragons
drags75521113_drag_s
enrages83114853enrages
eringos836913eringos
erugos7347343_erugos
forages114217283forages
frags96322173_frag_s
galagos938143galagos
garages9314113garages
ginkgos13314183ginkgos
girasol874623girasol
girasols984273girasols
giros65722653gir__os
gitanos837173gitanos
gregos847533_gregos
gringos936673gringos
hidalgos1342203hidalgos
images91411463_images
imago8118693_imago_
imagoes10126403_imagoes
irades74517393_irades
irokos1037233_irokos
largos74815063lar_gos
linages8813173linages
liras56021983lira__s
mikados1444683mikados
milages103114403milages
mirador1046503mirador
miradors1146853miradors
mirage92313653mirag_e
overages12513833overages
parados103816053parados
paragon10311023paragon
paragons11311503paragons
paramos113213513paramos
pargos95719043par_gos
pianos84315933pi_anos
picaros11310893picaros
pingos95317673pi_ngos
pipages1289423pipages
piragua1044643piragua
piraguas1144453piraguas
piranas9912603piranas
pirates93020333pirates
pirayas1277483pirayas
praos74923563_pra_os
ragas65326063__ragas
rages64539443__rages
raggs75216473__raggs
ragis66325603__ragis
rags55448373__rag_s
ratos55528763__ratos
rivages1138873rivages
sagos66123873__sagos
sargos74318273sar_gos
scrags95713803scrag_s
silages82514443silages
sorgos74514663sor_gos
sprags95715823sprag_s
tirades8311723tirades
tiros54524893tir__os
tragus749233_tragus
triages82613793triages
trigos74214173_trigos
turacos938643turacos
vagus96713813v__agus
varas86028193vara__s
verges104320183ver_ges
versos93812803ver_sos
vertigos1254973vertigos
vials85822383vi_a_ls
viands1047813vi_ands
viator93211833vi_ator
viators102712023vi_ators
vibrants1345913vibrants
vibrates132210613vibrates
vibrato12247383vibrato_
vibrator13227343vibrator
vibrators14237253vibrators
vibrios1235803vibrios
vicarages1574433vicarages
vicars11712263vica_rs
videos104911373vi_deos
vigas94817883vi__gas
vigor92612423vi__gor
vigors102911483vi__gors
vigs85427273vi__g_s
villages123010603villages
vinals94716483vina_ls
vinas85126343vina__s
vinos84723073vi__nos
vintages12118273vintages
viraginous1452873viraginous
viral86419593vira__l
virally1339653virally
vireo84816453vir_eo_
vires84529683vir__es
virga9310253vir_g_a
virgate1138733virgate
virgates1237923virgates
virgin1038083vir_gin
virgins1137863virgins
virion9310683vir_ion
virions1039873virions
virls85618603vir__ls
viroids1137923viroids
viroses10310533viroses
virosis1039023virosis
virtues10338023virtues
virtuosa1141943virtuosa
virtuose1143183virtuose
virtuosi1142123virtuosi
virtuoso1141873virtuoso
virtuous1144663virtuous
virtus94310143vir_tus
virus85316843vir__us
viruses1039413viruses
visage1049083visag_e
visaged1235683visaged
visards11328153visards
visas84317653visa__s
vitals94514303vita_ls
vitrains1138283vitrains
vivaces1536413vivaces
vivas114815023viva__s
vizards20377263vizards
vorlages1236033vorlages
voyages1435703voyages
zirams17438643zira_ms

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911340270.406440125.6
2DLD Change Limit1340271576.56320421.6
3Display Results1571570.0632492.1
 (SQL Overall)1786911577.03225411.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.