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

247 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
turbots98802(None) 
burbots1168671burbots
turbits969231turbits
turbos8910781turbo_s
turbot8914261turbot_
burbot10815652burbot_
tarots66422992tar_ots
trots56629942t_r_ots
tugboats11154102tugboats
turbans939562turbans
turbeth1274712turbeth
turbeths1373352turbeths
turbit8715112turbit_
turbith1267112turbith
turbiths1374082turbiths
turbo71015042turbo__
turbojets1852552turbojets
turgors836832turgors
turions7311572turions
turkois1135132turkois
turnons737862turnons
turnouts845412turnouts
turrets73010672turrets
abbots1039283_abbots
airboats1047283airboats
arbors84717883_arbors
argots74116033_argots
aurists74615783aurists
aurous64119263aur_ous
barbets114915843barbets
barbuts11439843barbuts
bots66453953___bots
bourbons1245343bourbons
brulots946223brulots
buboes104513993bu_boes
bulbous1138293bulbous
bumboats1445183bumboats
burbles114916803burbles
burbs95423493burb__s
burets84321263bur_ets
burgoos1037123burgoos
burgouts1145123burgouts
burnets93813263burnets
burnous938823burnous
burnouts1045263burnouts
burros85114993burro_s
burrows12399093burrows
bursts85116243bur_sts
burtons9310853burtons
busboys14325023busboys
carbons115418943carbons
carbos105122263carbo_s
carboys144711783carboys
carrots9714623carrots
cubits103714033cu_bits
curbers115514383curbers
curbs94821653curb__s
curets84922343cur_ets
curios83218333curio_s
curious93813563curious
cursors93910023cursors
curvets12399913curvets
dumbos114111083dumbo_s
durbars1077973durbars
durions839963durions
durocs9569703dur_ocs
duros65422693dur_o_s
enroots738713enroots
ergots74512373_ergots
euros54920243eur_o_s
furious103110633furious
furors9310953fur_ors
furrows13327793furrows
griots74713643_griots
grots65025853_gr_ots
gumboots1344253gumboots
gumbos114610873gumbo_s
gunboats1144823gunboats
gurnets84010793gurnets
guyots1036003gu_yots
harbors12412413harbors
harlots103413293harlots
heriots10312063heriots
hursts97213093hur_sts
hurts86922823hur__ts
jabots1538883_jabots
jerboas1636163jerboas
jumbos17379123jumbo_s
jurants14379213jurants
jurats134213203jur_ats
jurists14409123jurists
jurors1338283jur_ors
krubuts1343013krubuts
marmots11311513marmots
merlots92710123merlots
numbats1137673numbats
orbits84211443_orbits
outroots839873outroots
parrots9312743parrots
purists94014073purists
purports1265783purports
qubits173710353qu_bits
riots54922013__riots
robots8313153_robots
roots55933673__roots
rots46454093__r_ots
rubouts937983ru_bouts
ryots85313783__ryots
sabots8314703_sabots
sorbets93012513sorbets
sturts63915143stur__ts
sublots92410913sublots
sunbows1236023sunbows
surcoats1047943surcoats
surfboats1443563surfboats
surtouts846203surtouts
taboos83815433t_aboos
tabors84517113t_abors
taproots1047253taproots
tarboosh1343143tarboosh
targets84314223targets
tarocs84615663tar_ocs
taroks106115283tar_oks
taros55640823tar_o_s
tarot55943933tar_ot_
tarpons92612213tarpons
tarts57242023tar__ts
teapots939053teapots
terbias9310743terbias
tercets93512443tercets
termors94712773termors
terrets72913583terrets
territs72714503territs
terrors73112213terrors
threats104311673threats
thrifts1335523thrifts
throats104612193throats
throbs118311373thr_obs
throes97518673thr_oes
throws129715233thr_ows
thrusts10226523thrusts
tidbits1035183tidbits
tiros54524893tir_o_s
titbits935803titbits
tomboys1435713tomboys
toots55331873t__oots
toros54336193tor_o_s
torot56139943tor_ot_
toroth95512963tor_oth
torous64319033tor_ous
torpors939383torpors
torsos64815733torso_s
torts56138123tor__ts
tots46654123t___ots
tourists838313tourists
towboats1395333towboats
tracts85019073t_racts
traits65121983t_raits
treats64821693t_reats
trets55928023t_r_ets
tricots9311563tricots
triols66117803t_riols
trios55528093t_rio_s
trogs67022603t_r_ogs
trois57226093t_r_ois
troops85712783t_roops
trot46351313t_r_ot_
troth85622203t_r_oth
troths95414153t_r_oths
trouts66116633t_routs
trows88826183t_r_ows
troys86418613t_r_oys
truants738163truants
trusts64714433t_rusts
tryouts1035313t_ryouts
trysts9448793t_rysts
tubas75119583tu_b_as
tubate82813173tu_bate
tubbers113411253tubbers
tubers85017033tu_bers
tubes74826453tu_b_es
tubist83013163tu_bist
tubists9288323tubists
tubs65430063tu_b__s
tuckets134810333tuckets
tuffets13266523tuffets
tufts85713273tu__fts
tugboat10126103tugboat
tumbles113816023tumbles
tumors8810613tu_mors
tumults934823tumults
turacos938643turacos
turacous1047143turacous
turban8310483turb_an
turbary1236383turbary
turbid979713turb_id
turbine9310303turbine
turbines1039903turbines
turbocar1243363turbocar
turbocars1343073turbocars
turbofan1342593turbofan
turbofans1442283turbofans
turbojet1755383turbojet
turds65021693tur__ds
tureens7289873tureens
turfs84620443tur__fs
turgite837973turgite
turgites937783turgites
turgor736863turgo_r
turion6313163turio_n
turista737443turista
turistas846693turistas
turkeys1434523turkeys
turks95320823tur__ks
turmoil944723turmoil
turmoils1043983turmoils
turnabouts1252103turnabouts
turncoats1143013turncoats
turners73912893turners
turnips935013turnips
turnoff1344013turnoff
turnoffs1442833turnoffs
turnon638193turno_n
turnout7410283turnout
turns55623243tur__ns
turnups933893turnups
turpeth1284813turpeth
turpeths1373153turpeths
turps74918733tur__ps
turquois1742453turquois
turret63121853turret_
turtles72914343turtles
turves94212693tur_ves
tussors7388773tussors
tutors6912333tu_tors
tuts45838453tu___ts
tyrants1037453tyrants
tyros85118593tyr_o_s
umbos94613073_umbo_s
unbolts9247803_unbolts
unroots738563unroots
upbows1384683_upbows
uproots937143uproots
urbias839093_urbias
urbs65922063_urb__s
wursts95211163wur_sts
yurts87216533yur__ts

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.406440125.6
2DLD Change Limit1340272476.26321399.8
3Display Results2472470.0962572.9
 (SQL Overall)1786912476.76526414.0
 
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.