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

97 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
chauffer1926379(None) 
chaffer18389471cha_ffer
chaufer15347941chau_fer
chauffers20253441chauffers
chauffeur20221981chauffeur
chuffer18337141ch_uffer
chafer144714572cha__fer
chaffed19387702cha_ffed
chaffers19378002cha_ffers
chaffier1935472chaffier
chamfer17399862cha_mfer
chaufers16347302chau_fers
chauffeurs21221612chauffeurs
chaunter1366392chaunter
chuffed19316642ch_uffed
chuffier1934542ch_uffier
gauffer1474422_gauffer
bluffer15396883_bluffer
buffer144512683__buffer
caulker13456893c_aulker
causer84117783c_au_ser
chafe135117353cha__fe_
chafed154813913cha__fed
chafers154512743cha__fers
chafes145017913cha__fes
chaff165016283cha_ff__
chaffered21154483cha_ffered
chafferer20133923chafferer
chaffs17459613cha_ff_s
chaffy20456473cha_ff_y
chalkier1736753chalkier
chamber164011063cha_mber
chamferer19154693chamferer
chamfers18409223cha_mfers
champer163813413cha_mper
chancer144215633cha_ncer
chancier1538823chancier
chandler14358373chandler
changer134215543cha_nger
chanter123919733cha_nter
chapiter1536603chapiter
chapter144213853cha_pter
charger133914063cha_rger
charier124317903cha_rier
charmer144913663cha_rmer
charrier1378683charrier
charter123918303cha_rter
chaser114918383cha__ser
chaster124718503cha_ster
chatter124416643cha_tter
chattier1337513chattier
chauffeured235883chauffeured
chaunted1485603chaunted
chaunters1455823chaunters
chausses1345963chausses
chawer144314413cha__wer
cheffed19335863ch_effed
chiefer1536863ch_iefer
chouser125212943chou_ser
chudder14245943ch_udder
chuff164812493ch_uff__
chuffest1944193ch_uffest
chuffs17427783ch_uff_s
chuffy20445863ch_uff_y
chugger1445373ch_ugger
chukker1543833ch_ukker
chunter123911483ch_unter
churner12298343ch_urner
coffer144112863c__offer
crafter124111333cra_fter
cuffed154311213c__uffed
duffer134711663__duffer
fluffer12336503_fluffer
gaffer134310133_ga_ffer
gauffers1563833_gauffers
gruffer1475793_gruffer
haffet15311703_ha_ffet
hafter124815883_ha_fter
hauler95015123_hau_ler
haulier1059943_haulier
haunter103111153_haunter
huffed163710153_h_uffed
huffier1637493_h_uffier
piaffer15104443pia_ffer
puffer144610733__puffer
quaffer2235133qua_ffer
rechauffe2051583rechauffe_
rechauffes2151463rechauffes
sclaffer16112653scla_ffer
scuffer15328883_scuffer
shuffler17306803sh_uffler
snuffer13318853_snuffer
staffer13299093sta_ffer
stuffer13349793_stuffer
suffer124314513__suffer
whiffer19105323wh_iffer
zaffer21397153_za_ffer

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.453394461.4
2DLD Change Limit146162977.18620339.8
3Display Results97970.0332939.4
 (SQL Overall)178691977.67223291.3
 
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.