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 “krubuts” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

83 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
krubuts134301(None) 
krubut1245551krubut_
krauts10418512kr_auts
krubis1235002krub_is
rebuts84015192_rebuts
rubouts937982_rubouts
rubus76415062_rubu_s
abuts75417073__abuts
arbute8311043ar_bute
arbutes939703ar_butes
arbutus944843ar_butus
barbuts11439843barbuts
bruits85714453bru_its
brulots946223brulots
brunets9419553brunets
brunts85215453bru_nts
bruts75922953br__uts
bubus95115453_bubu_s
burbots1168673burbots
buts67247693___buts
bututs8409423_bututs
cruets85314953cru_ets
crumbums1642733crumbums
crusets93811043crusets
crusts84916543cru_sts
cubits103714033_cubits
debuts93911753_debuts
doubts968733doub_ts
drubs85913833drub__s
eructs83610793eru_cts
erupts8348903eru_pts
fruits94512493fru_its
grouts75015613gr_outs
grubs86312603grub__s
grunts75511853gru_nts
hagbuts1354933hagbuts
kibbutz2442533kibbutz
knouts10438313k_nouts
kombus1435523kombu_s
krafts13438853kr_afts
kraits104912203kr_aits
kraut95221403kr_aut_
krubi1136523krub__i
kudus104910803k_udu_s
kurus98015633k_uru_s
orbits84211443or_bits
prebuys1444393prebuys
precuts111710473precuts
probits112712573probits
prunus8399363prunu_s
qubits173710353_qubits
rabats83116223_rabats
rebus75721113_rebu_s
rebut75927383_rebut_
rebuys11428783_rebuys
recuts83817373_recuts
robots8313153_robots
robust8310433_robust
routs57133413_r_outs
rubati8299693_rubati
rubato8319683_rubato
rubatos9278653_rubatos
rubels84112993_rubels
rubes74928413_rub_es
rubies84420343_rubies
rubles83921703_rubles
rubout8313563_rubout_
rubs66133493_rub__s
runouts737353_runouts
runts55927633_ru_nts
rusts55026993_ru_sts
ruts44541493_r__uts
sacbuts1166473sacbuts
sagbuts1065223sagbuts
thruputs1341963thruputs
tribute937313tribute
tributes1047233tributes
trouts66116633tr_outs
truants738163truants
trusts64714433tru_sts
tryouts1035313tryouts
turbits969233turbits
turbots988023turbots

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 Limit134027835.84322938.0
3Display Results83830.0165187.5
 (SQL Overall)178691836.26528522.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.