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

205 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
hauteur103389(None) 
auteur6107941_auteur
hauteurs1133731hauteurs
auteurs7137502_auteurs
hafter124815882hafte_r
halter94420882halte_r
hater85034752ha_te_r
hatter94724872hatte_r
hauler95015122haule_r
haunter103111152haunte_r
haute89521612haute__
tauter64318022taute_r
acuter84412863acute_r
after85719793_afte_r
alter54828503_alte_r
amateur933883amateur
apter76120203_apte_r
aster55434893_aste_r
auger64922473_auge_r
augur64311213_au_gur
aureus65314883_aureus
author939763_author
baiter84422553baite_r
banter84825333bante_r
barter85525373barte_r
baster85333593baste_r
batter84928873batte_r
canter85230113cante_r
carter84932273carte_r
caster85232573caste_r
cater74840703ca_te_r
causer84117783cause_r
cautery12349573cautery
chanter123919733chante_r
chapter144213853chapte_r
charter123918303charte_r
chasseur1343433chasseur
chaster124718503chaste_r
chatter124416643chatte_r
chaufer15347943chaufe_r
chauffeur20221983chauffeur
chaunter1366383chaunte_r
couter84930203coute_r
cuter74728223_cute_r
dafter104813343dafte_r
danseur833663danseur
darter75320363darte_r
dater65332313da_te_r
dauber94112013daube_r
daunter83811753daunte_r
dauted84114933daute_d
douceur1043113douceur
easter65027983easte_r
eater54639843ea_te_r
faitour1034883faitour
falter94519053falte_r
farceur12525273farceur
faster94625773faste_r
fatter94523213fatte_r
fauteuil1142023fauteuil
fluter95316863flute_r
gaiter73819503gaite_r
garter74420513garte_r
gaster75027353gaste_r
gater64533643ga_te_r
gauger84714853gauge_r
gaunter82910713gaunte_r
gluteus8386253gluteus
hacker154822693hacke_r
hafted134713833hafte_d
hafters134614333hafters
hailer94720343haile_r
haler85033523ha_le_r
haleru94212073ha_leru
halted105019603halte_d
haltere103614703haltere
halters104619803halters
hammer138120033hamme_r
hamper134518653hampe_r
hamster12810423hamste_r
hander104526433hande_r
hanger104023253hange_r
hanker134622093hanke_r
hanted104124313hante_d
hapten115312983hapte_n
haptene123810933haptene
haptens124511343haptens
harbour1247053harbour
harder105022403harde_r
harmer114719553harme_r
harper115018403harpe_r
haste85927863haste__
hasted105125283haste_d
hasteful14105253hasteful
hasten95718563haste_n
hastener11259133hastener
hastens106214813hastens
hastes95727073haste_s
hastier103916623hastier
hate78450173ha_te__
hated95734023ha_te_d
hateful13107683ha_teful
haters94930393ha_ters
hates86742573ha_te_s
hatful12108743ha_tful
hatted104921513hatte_d
hatters104221523hatters
hauberk1633463hauberk
hauled104415213haule_d
haulers104012443haulers
haulier1059943haulier
haunted11399733haunte_d
haunters11329533haunters
hausen9610383hause_n
hausens1077633hausens
haut75949733haut___
hautboy1553423hautboy
haver115124463ha_ve_r
haviour1354823haviour
hawker164812663hawke_r
hawser125910843hawse_r
hayer114620243ha_ye_r
hazer174820233ha_ze_r
hazier184712403hazie_r
heater94828303heate_r
hefter124313923hefte_r
hinter94021303hinte_r
hitter94419863hitte_r
hooter94123923hoote_r
hotter94720073hotte_r
houser95322283house_r
huger94914873h_uge_r
humour11116753h_umour
hunter94817773hunte_r
hurter93915853hurte_r
laster64830633laste_r
later54843923la_te_r
latter65027893latte_r
lauder73815013laude_r
luteum837783_luteum
masseur935703masseur
master84831343maste_r
mater74438863ma_te_r
matter84325343matte_r
mauger93813483mauge_r
mauler84416713maule_r
muter74525543_mute_r
natter64420743natte_r
neuter63713793neute_r
oater55433733oa_te_r
outer55633303_oute_r
palter84423263palte_r
paster85734373paste_r
pasteup1134983pasteup
pater74740723pa_te_r
patter84628263patte_r
pauper103511943paupe_r
pauser84415963pause_r
phatter123810203phatte_r
pluteus9326243pluteus
pouter83923983poute_r
rafter94517583rafte_r
ranter63826823rante_r
raster64731443raste_r
rater54943283ra_te_r
ratter64326313ratte_r
router65025843route_r
saboteur1041993saboteur
salter64325083salte_r
saluter73512453salute_r
santour737373santour
santur6311273sant_ur
saucer84314103sauce_r
sauger74316253sauge_r
saunter72913453saunte_r
saute55028083saute__
sauted74119603saute_d
sauteed8349613sauteed
sautes63924913saute_s
sautoir735163sautoir
shatter103615693shatte_r
shouter103213073shoute_r
souter64225923soute_r
tarter64023563tarte_r
taster64930573taste_r
tater54138613ta_te_r
tatter64024573tatte_r
taunter73111453taunte_r
tautaug883023tautaug
tauted75317113taute_d
tauten64311893taute_n
tautens7317843tautens
tautest72612443tautest
touter63821033toute_r
vaster94521023vaste_r
vaulter10257713vaulte_r
vaunter10309603vaunte_r
wafter124114613wafte_r
waiter94321253waite_r
wanter94423053wante_r
waster95228943waste_r
water84733313wa_te_r
watter93221983watte_r
yatter94116213yatte_r
yauper11368543yaupe_r

Search took 9 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.1731032896.0
2DLD Change Limit1340272057.92016922.6
3Display Results2052050.0802562.5
 (SQL Overall)1786912058.17321863.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.