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

117 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
burrito93622(None) 
burritos1044471burritos
barrio8312572barri_o
burkite1337002burkite
burrier93613552burrier
burring104016992burring
burro75018492burr__o
bandito103710043bandito
barite84224813b_arite
barrator1048403barrator
barret84930483barret_
barretor1046713barretor
barrets94917103barrets
barrier94017733barrier
barring104021593barring
barrios9310773barrios
berried103714043berried
berries94423553berries
birring103713063birring
blurrier1035163blurrier
blurrily1343913blurrily
blurring11277233blurring
bonito8313433b_onito
bornite9311183bornite
bourride1144403bourride
brio65432493b__ri_o
brit66350153b__rit_
brith104924373b__rith
brits76433083b__rits
britt75732233b__ritt
bruit76126723b_ruit_
bruits85714453b_ruits
burbot10815653burbot_
burbots1168673burbots
burdie93615023burdi_e
burdies104117563burdies
buret77444013bu_ret_
burets84321263bu_rets
burette939853burette
burgoo938933bu_rgoo
burial84117623bu_rial
buried94822373bu_ried
burier84324653bu_rier
buries84633273bu_ries
burin75626063bu_ri_n
burins84221893bu_rins
burking143716323burking
burkites1436673burkites
burlier93514413burlier
burlily1237713burlily
burling104421133burling
burnet84326173burnet_
burnets93813263burnets
burnie83715413burni_e
burnies94017823burnies
burning104215503burning
burnish1238623burnish
burnt75230333bu_rnt_
burping124012943burping
burr65631233burr___
burred95820723burr_ed
burrer83718473burr_er
burrers93814493burrers
burriest102911213burriest
burros85114993burr_os
burrow114610803burr_ow
burrows12399093burrows
burrs74925653burr__s
burrstone1183993burrstone
burry105221563burr__y
bursate94111203bursate
bursitis1045033bursitis
burst75332243bu_rst_
bursts85116243bu_rsts
burton8311273bu_r_ton
burying133413913burying
bushido1344453bushido
cuprite1159683cuprite
curio74221213cu_ri_o
curite85222943cu_rite
currie84317263curri_e
curried103313653curried
currier93316703currier
curries93723163curries
curring103616843curring
currish1238353currish
durrie73713263durri_e
durries83817353durries
eucrite939903eucrite
ferrite103312753ferrite
forrit91916623forrit_
furmity1535183furmity
furrier103513663furrier
furrily1337613furrily
furring114013143furring
gurries83515953gurries
hornito1047073hornito
hurried113511043hurried
hurrier103412943hurrier
hurries103919653hurries
murries94118673murries
murrine9411483murrine
prurigo1043023prurigo
purity114114913pu_rity
purring104515823purring
quarto153511123quar_to
subito8410453su_bito
territ63421373territ_
territs72714503territs
turbit8715113turbit_
turbith1267113turbith
turbits969233turbits
turgite837973turgite
turret63121853turret_
turrets73010673turrets
worrit92313313worrit_
worrits10258683worrits

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 Limit1340271176.78019768.0
3Display Results1171170.0502340.0
 (SQL Overall)1786911177.23624694.7
 
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.