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 “bureaux” 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
bureaux166459(None) 
bureau8712521bureau_
bureaus979291bureaus
bateaux1693882bateaux
beaux146513212b__eaux
bordeaux1843272bordeaux
aureate72515283aureate
aureus65314883aure_us
bandeaux1843293bandeaux
bateau8810563bateau_
batteaux1742503batteaux
beau66137273b__eau_
beaus75127113b__eaus
beaut75135213b__eaut
bereave1258353bereave
borax145918723bor_a_x
boreal84817213borea_l
boreas85421733borea_s
breach134213723b_reach
bread85523113b_rea_d
breads95419203b_reads
bready124511183b_ready
break115319403b_rea_k
breaks124816423b_reaks
breakup1543463b_reakup
bream95121813b_rea_m
breams104815043b_reams
breast8319633b_reast
breath113916263b_reath
brux136315273b_r__ux
bura66139533bur_a__
buran75225303bur_a_n
burans85019303bur_ans
buras74736293bur_a_s
buret77444013bure__t
burets84321263bure_ts
burette939853burette
burgage1136633burgage
burgout1049773burgout
burial84117623buria_l
burials93612083burials
burka114617693burka__
burkas124513803burka_s
burlap1098353burla_p
burlaps1156253burlaps
burnous938823burnous
burnout9310453burnout
burqa165013093burqa__
burqas174410903burqa_s
bursa74921523bursa__
bursae84515603bursa_e
bursal84414823bursa_l
bursar85413253bursa_r
bursars94510893bursars
bursary12397583bursary
bursas85318273bursa_s
bursate94111203bursate
coteaux1643723coteaux
couteaux1743203couteaux
eaux116618423___eaux
gateaux1573123gateaux
lurex124816733lure__x
morceaux1942223morceaux
murex145517173mure__x
redux133811103__redux
reseaux14326233reseaux
rouleaux1542473rouleaux
subbureaux2151113subbureaux
surtax1337843surta_x
trumeaux1741573trumeaux
uraeus638793_uraeus
urea46528053_urea__
ureal56722683_urea_l
ureas55826013_urea_s
urease64516993_urease

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 Filter1786911340270.1561145455.1
2DLD Change Limit134027755.79623124.1
3Display Results75750.0164687.5
 (SQL Overall)178691755.96829941.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.