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 “turacos” 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.

223 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
turacos93864(None) 
touracos1045311touracos
turaco839451turaco_
turacou945511turacou
turacous1047141turacous
curacaos1244922curacaos
curacoa1146222curacoa
curacoas1246032curacoas
guacos94410312gu_acos
tacos77023552t__acos
touraco945362touraco_
traces85329932t_races
tracks124818842t_racks
tracts85019072t_racts
turbos8910782tur_bos
arracks1387733arracks
attracts1047793attracts
auras55932563aura__s
aurochs1245983aurochs
boraces113716853boraces
braces108427773_braces
brachs134415753_brachs
bracts105617773_bracts
bravos114711403_bravos
buncos104011593bu_ncos
burans85019303bura_ns
buras74736303bura__s
burgoos1037123burgoos
burros85114993bur_ros
caracks152211563caracks
caracol11310423caracol
caracols12310413caracols
cracks144817003_cracks
curacao1146293curacao
curacies12311763curacies
curacy1339593curac_y
curaghs1334583curaghs
curaras93911953curaras
curares94916853curares
curaris94114773curaris
curates95323833curates
curator9312213curator
curators10311723curators
curios83218333cur_ios
currachs1544543currachs
dorados938203dorados
durances1158683durances
duras65727733dura__s
durocs9569703duroc_s
duros65422693dur__os
euros54920243eur__os
fracas11311993_fracas
fugatos1135483fugatos
furanes103214863furanes
furanose1144753furanose
furans94515953fura_ns
furnaces1336053furnaces
graces94523493_graces
guaco85012163gu_aco_
guanacos1163813guanacos
guanos73811993gu_anos
huarachos1743283huarachos
hyraces1537913hyraces
jucos144111713ju__cos
juncos15449233ju_ncos
jurants14379213jurants
jurats134213203jura_ts
macacos1338083macacos
maracas11313773maracas
murals84016763mura_ls
muras75329583mura__s
murices112612283murices
narcos86714203nar_cos
ourangs8318503ourangs
ouraris73512933ouraris
outacts9310213outacts
outraces102217863outraces
parados103816053parados
paramos113213513paramos
praos74923563_pra_os
puranas9712653puranas
quacks214710103qu_acks
quartos16328743quartos
races74943243__races
racks115028853__racks
racon75422143__racon
racons84319343__racons
ratos55528773__ratos
reracks132310533reracks
rubaces1139313rubaces
rubatos9278663rubatos
seracs84418573serac_s
stuccos1153933stu_ccos
subraces12313033subraces
sumachs14457353sumachs
sumacs105512103sumac_s
surahs94515543sura_hs
suras55336333sura__s
surfaces1338673surfaces
taces76237803t__aces
tachs105820933t__achs
tacks115430133t__acks
taco67031353t__aco_
tacts76524123t__acts
taos45541003t__a_os
tapalos938813tapalos
taramas9612713taramas
tarmacs1138333tarmac_s
tarocs84615663taroc_s
taros55640823t__aros
telcos8710683t_elcos
tenaces92814513tenaces
terais64023513tera_is
terces83921413ter_ces
teredos839183teredos
terraces102712253terraces
thacks154311923t_hacks
thoraces13118943thoraces
thralls10299043thralls
thraves13469713thraves
thraws129211103thra_ws
thwacks1953613thwacks
tirades8311723tirades
tiros54524893tir__os
tobaccos1442343tobaccos
torahs95115643tora_hs
toras55540373tora__s
torcs75123763tor_c_s
toreros7311343toreros
torics85118353toric_s
tornados945373tornados
toros54336193tor__os
torsos64815733tor_sos
trace75829613t_rac_e
traced94821583t_raced
tracer84820233t_racer
tracers94917843t_racers
track114823013t_rac_k
tract75635713t_rac_t
tractor9311343t_ractor
tractors10312573t_ractors
trades75724503t_rades
tragus749233t_ragus
traiks104013713t_raiks
trails64622513t_rails
trains64725343t_rains
traits65121983t_raits
tramps105114453t_ramps
trams75327673t_ra_ms
trances93919643t_rances
tranks104017763t_ranks
tranqs155210313t_ranqs
trans54933043t_ra_ns
trapes85024463t_rapes
traps75727483t_ra_ps
trass56226473t_ra_ss
traves94222743t_raves
travois1037883t_ravois
trawls94412393t_rawls
trays85623433t_ra_ys
triacs83913223triac_s
trices84826333t_rices
tricks125319013t_ricks
tricot8317753t_ricot
tricots9311563t_ricots
trigos74214173t_rigos
trios55528093t_r_ios
tripos84014923t_ripos
trocks123614633t_rocks
truants738163truants
truces84916333t_ruces
trucks124711973t_rucks
tubas75119583tuba__s
tucks114721123tu__cks
tufaceous1442863tufaceous
tufas85314383tufa__s
tuladis835703tuladis
tunas54224123tuna__s
tunics83811263tunic_s
tupelos936113tupelos
turbans939563turbans
turbits969233turbits
turbo71015043tur_bo_
turbot8914263tur_bot
turbots988023turbots
turds65021693tur__ds
tureens7289873tureens
turfs84620443tur__fs
turgor736863tur_gor
turgors836833turgors
turion6313163tur_ion
turions7311573turions
turkeys1434523turkeys
turkois1135133turkois
turks95320823tur__ks
turncoat1044853turncoat
turncoats1143013turncoats
turners73912893turners
turnips935013turnips
turnon638193tur_non
turnons737863turnons
turns55623243tur__ns
turnups933893turnups
turps74918733tur__ps
turquois1742453turquois
turrets73010673turrets
turtles72914343turtles
turves94212693tur_ves
tuxedos1543293tuxedos
tyrants1037453tyrants
tyros85118593tyr__os
uncos74117033_u_ncos
uracil8311543_uracil
uracils939373_uracils
uraeus638793_uraeus
uranous7310733_uranous
urares64519093_urares
uraris63817273_uraris
urases63723563_urases
urates65027763_urates
uredos73910623_uredos
viragos1146713viragos
wracks154711113_wracks

Search took 7 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.420425454.8
2DLD Change Limit1340272236.47020715.1
3Display Results2232230.0802787.5
 (SQL Overall)1786912236.97025637.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.