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

75 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
burritos104447(None) 
burrito936221burrito_
barrios9310772barri_os
burkites1436672burkites
burros85114992burr__os
bursitis1045032bursitis
banditos11347633banditos
barites94322333b_arites
barrator1048403barrator
barrators1148393barrators
barretor1046713barretor
barretors1146243barretors
barrets94917103barret_s
barriers104311883barriers
barrio8312573barri_o_
berries94423553berri_es
bonitos939733b_onitos
bornites10310983bornites
bourrides1244823bourrides
brios74725723b__ri_os
briths115113863b__riths
brits76433083b__rit_s
britts84813443b__ritts
bruits85714453b_ruit_s
burbots1168673burbot_s
burdies104117563burdi_es
burets84321263bu_ret_s
burettes1048953burettes
burgoos1037123bu_rgoos
burials93612083bu_rials
buriers94017193bu_riers
buries84633273bu_ri_es
burins84221893bu_ri_ns
burkite1337003burkit_e
burnets93813263burnet_s
burnies94017823burni_es
burnings11387623burnings
burrers93814493burr_ers
burrier93613553burri_er
burriest102911213burriest
burring104016993burri_ng
burro75018493burr__o_
burrow114610803burr__ow
burrows12399093burr_ows
burrs74925653burr___s
burrstone1183993burrstone
burrstones12113833burrstones
bursts85116243bu_rst_s
burton8311273bu_r_ton
burtons9310853bu_r_tons
bushidos1443083bushidos
cuprites1259023cuprites
curios83218333cu_ri_os
curites93919863cu_rites
curriers103410753curriers
curries93723163curri_es
durries83817353durri_es
eucrites1049483eucrites
ferrites112312833ferrites
furriers11369493furriers
furrings12317143furrings
gurries83515953gurri_es
hornitos1145393hornitos
hurriers11358893hurriers
hurries103919653hurri_es
murries94118673murri_es
prurigos1142363prurigos
pruritus1043943pruritus
quartos16328733quar_tos
territs72714503territ_s
turbiths1374083turbiths
turbits969233turbit_s
turgites937783turgites
turrets73010673turret_s
worrits10258683worrit_s

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 Filter1786911461620.423422437.4
2DLD Change Limit146162756.64022012.3
3Display Results75750.0164687.5
 (SQL Overall)178691757.07925242.4
 
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.