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

292 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
turbot891426(None) 
burbot10815651burbot
turbit8715111turbit
turbo71015041turbo_
turbos8910781turbos
turbots988021turbots
burbots1168672burbots
tarot55943932tar_ot
torot56139942tor_ot
trot46351312t_r_ot
tugboat10126102tugboat
turban8310482turban
turbeth1274712turbeth
turbid979712turbid
turbith1267112turbith
turbits969232turbits
turbojet1755382turbojet
turgor736862turgor
turion6313162turion
turnon638192turnon
turnout7410282turnout
turret63121852turret
abbot9318453_abbot
airboat9512133airboat
arbor74818113_arbor
argot67728653_argot
aurist65027253aurist
barbet104427883barbet
barbut104617003barbut
bot59680403___bot
bourbon1135813bourbon
brulot8912213brulot
bubo85621913bu_bo_
bumboat1349023bumboat
burb85334673burb__
burble104617703burble
burbly134311153burbly
burbs95423493burb_s
buret77444013bur_et
burgoo938933burgoo
burgout1049773burgout
burnet84326173burnet
burnout9310453burnout
burnt75230323bur_nt
burro75018493burro_
burros85114993burros
burrow114610803burrow
burst75332243bur_st
burton8311273burton
busboy13307443busboy
carbo94923843carbo_
carbon104919043carbon
carbos105122263carbos
carboy134914183carboy
carrot8423123carrot
cubit94122893cu_bit
curb86732223curb__
curbed114615873curbed
curber104517053curber
curbs94821653curb_s
curet75447643cur_et
curio74221213curio_
curios83218333curios
cursor84110293cursor
curst74931023cur_st
curt67051713cur__t
curvet114720243curvet
dumbo105614063dumbo_
dumbos114111083dumbos
durbar968723durbar
durion7510963durion
duro56228023dur_o_
duroc84513143dur_oc
duros65422693dur_os
durst66125173dur_st
enroot6615993enroot
ergot65422893_ergot
euro45325273eur_o_
euros54920243eur_os
forgot104318133forgot
furor8312393fur_or
furrow12427743furrow
griot65328413_griot
grot55942053_gr_ot
gumbo104413583gumbo_
gumboot1246493gumboot
gumbos114610873gumbos
gunboat1047363gunboat
gurnet74920873gurnet
guyot9314523gu_yot
harbor11410723harbor
harlot94422803harlot
heriot9422343heriot
hurst85527193hur_st
hurt77142573hur__t
jabot14321513_jabot
jerboa1535633jerboa
jumbo164311073jumbo_
jumbos17379123jumbos
jurant134216553jurant
jurat124829323jur_at
jurist134616393jurist
juror1239563jur_or
krubut1245553krubut
lirot5430033lir_ot
marmot10318743marmot
merlot83217603merlot
numbat10312083numbat
orbit73622063_orbit
outbox1537463outbox
outroot7516563outroot
parrot8320663parrot
prutot8311823prutot
purest84021933purest
purist85525053purist
purport1159393purport
qubit164218993qu_bit
riot45947213__riot
robot7325973_robot
root45655923__root
rot37282953__r_ot
rubout8313563ru_bout
rurban849043rurban
ryot75528563__ryot
sabot7931783_sabot
sorbet83924083sorbet
sturt56028963stur__t
sublot82315523sublot
sukkot936643sukkot
sunbow1145823sunbow
surcoat9412923surcoat
surest65026763surest
surfboat1345333surfboat
surtout7411673surtout
taboo73418093t_aboo
tabor75518393t_abor
taproot9412673taproot
tardo65321103tardo_
target75028903target
taro46846913tar_o_
taroc75721643tar_oc
tarok97921073tar_ok
taros55640823tar_os
tarots66422993tar_ots
tarpon82812803tarpon
tart47566183tar__t
teabox1536013teabox
teapot8416763teapot
terbia8311153terbia
terbic10410963terbic
tercet83624913tercet
termor84412513termor
terret63425623terret
territ63421373territ
terror63811733terror
threat95020463threat
thrift12412043thrift
thro77726423thr_o_
throat94819753throat
throb109816853thr_ob
throbs118311373throbs
throe89321423thr_oe
throw118719733thr_ow
thrust91911893thrust
tidbit938493tidbit
tinpot8312513tinpot
tiro46832363tir_o_
tiros54524893tir_os
titbit839823titbit
tomboy1358213tomboy
toot45958883t__oot
toro48045683tor_o_
toros54336193tor_os
toroth95512963tor_oth
torpor839193torpor
torso56922143torso_
torsos64815733torsos
tort46967463tor__t
tot38884773t___ot
tourist7313203tourist
towboat1258303towboat
tract75635713t_ract
trait56940843t_rait
trapt76433393t_rapt
treat56240353t_reat
tret46653533t_r_et
tricot8317753tricot
trio45233343t_rio_
triol55521363t_riol
trios55528093t_rios
trod57627953t_r_od
trog57628213t_r_og
troop76417533t_roop
trooz145016153t_rooz
trop66833303t_r_op
troth85622203t_r_oth
trots56629943t_r_ots
trout57332573t_rout
trow78031423t_r_ow
troy77429683t_r_oy
truant6315783truant
truest64816193truest
trust55426853t_rust
tryout9410753t_ryout
tryst84716223t_ryst
tub55640033tu_b__
tuba65422363tu_b_a
tubae74716643tu_bae
tubal75517203tu_bal
tubas75119583tu_bas
tubate82813173tu_bate
tubbed114712223tubbed
tubber104313203tubber
tubby124511403tu_bby
tube65828663tu_b_e
tubed85818043tu_bed
tuber75420683tu_ber
tubes74826453tu_bes
tubist83013163tubist
tubs65430063tu_b_s
tucket124219483tucket
tuffet122612083tuffet
tuft76929513tu__ft
tugboats11154103tugboats
tumble103215643tumble
tumor71110693tu_mor
tumult839703tumult
turaco839453turaco
turacos938643turacos
turacou945513turacou
turbans939563turbans
turbary1236383turbary
turbeths1373353turbeths
turbine9310303turbine
turbiths1374083turbiths
turbocar1243363turbocar
turbofan1342593turbofan
turbojets1852553turbojets
turd56027623tur__d
turds65021693tur_ds
tureen63312723tureen
turf75334053tur__f
turfed103110963turfed
turfs84620443tur_fs
turfy114315403tur_fy
turgent8712393turgent
turgid868013turgid
turgite837973turgite
turgors836833turgors
turions7311573turions
turista737443turista
turk86125863tur__k
turkey1337763turkey
turkois1135133turkois
turks95320823tur_ks
turmoil944723turmoil
turn46330383tur__n
turnabout1153753turnabout
turncoat1044853turncoat
turned73914473turned
turner63914613turner
turnip836593turnip
turnoff1344013turnoff
turnons737863turnons
turnouts845413turnouts
turns55623233tur_ns
turnup835093turnup
turpeth1284813turpeth
turps74918733tur_ps
turrets73010673turrets
turtle63213573turtle
turves94212693turves
tussor6378233tussor
tut36758093tu___t
tutor5712493tu_tor
tyrant9315333tyrant
tyro76622363tyr_o_
tyros85118593tyr_os
umbo85516663_umbo_
umbos94613073_umbos
unbolt83013893_unbolt
unbox1438753_unbox
ungot61718063_ungot
unroot6315553unroot
upbow1245613_upbow
uproot8314123uproot
urb55731103_urb__
urban72013863_urban
urbia7311143_urbia
urbs65922053_urb_s
wurst85122993wur_st
yurt76435043yur__t

Search took 6 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162925.53320371.6
3Display Results2922920.0933139.8
 (SQL Overall)1786912925.76630990.5
 
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.