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

142 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
friseur103367(None) 
friseurs1133301friseurs
diseur738842_diseur
frier85225842fri_e_r
frise85322452frise__
frisee94217992frise_e
frisees104411692frisees
frises94124272frise_s
frisker14389272frisker
frizer184011282frize_r
riser55431052_rise_r
arider74717743aride_r
arise56436433arise__
arisen65316793arise_n
arises65233803arise_s
briber104714053bribe_r
brier74527403bri_e_r
briner84519043brine_r
brises84927613brise_s
brisker134210293brisker
bruiser9349573bruise_r
crier74724463cri_e_r
crises84529433crise_s
crisper113511053crisper
crissum1144843crissum
crittur9315133crittur
cruiser93410433cruise_r
danseur833663danseur
diseurs839403_diseurs
drier64423963dri_e_r
driver104714493drive_r
ecraseur1041803ecraseur
eraser64216333erase_r
fainer94717243faine_r
fairer95212063faire_r
faitour1034883faitour
falser93912413false_r
farceur12525273farceur
fiber104921133f_ibe_r
fifer115519973f_ife_r
filer85433003f_ile_r
finer85431563f_ine_r
firer811229253f_ire_r
firmer114712443firme_r
fisher124917143f_isher
fissure1036783f_issure
fiver116024943f_ive_r
fixer154717833f_ixe_r
flaneur1034183flaneur
flier86023403fli_e_r
foreseer1139013foreseer
fractur12135563fractur
frailer10319943fraile_r
fraise94214913fraise__
fraises104215693fraise_s
fraktur14153033fraktur
framer114817443frame_r
frater94520593frate_r
freer86021243fr__eer
fresher132612643fresher
friar85414273fri__ar
fried95322913fri_e_d
friend10388933fri_end
friers94718933fri_ers
fries85535603fri_e_s
frieze18378143fri_eze
friges104116483frige_s
friller104111743friller
frisbee12298513frisbee
frisbees13295013frisbees
frisette1195483frisette
frisk125312373fris__k
frisked15478823frisked
friskers15337373friskers
frisket143811773frisket
friskets15326263friskets
friskier1535193friskier
frisks13479263fris_ks
frisky16406673fris_ky
frisson1045313frisson
frites94922483frite_s
fritter103912773fritter
frized193510683frize_d
frizers19329553frizers
frizes184015463frize_s
frizzer18446893frizzer
frondeur1242793frondeur
frotteur1142503frotteur
fruiter10309683fruite_r
frustum1243953frustum
fryer115913433fr_ye_r
fusser94813773fusse_r
griper94114613gripe_r
griseous945613griseous
grister83915413grister
irised73913153irise_d
irises64221173irise_s
kaiser103610373kaise_r
krises105016083krise_s
masseur935703masseur
miser75430403_mise_r
poiser84217243poise_r
poseur8419403_poseur
praiser93413943praise_r
pricer103918293price_r
prier75027763pri_e_r
primer105118683prime_r
prise74632613prise__
prised94322203prise_d
prisere9310943prisere
prises84133173prise_s
prizer174714883prize_r
proser84223463prose_r
raiser66620103raise_r
raser55633413_rase_r
ricer74726613_rice_r
rider65231303_ride_r
rifer84721983_rife_r
rigour7258023_rigour
rimer75429243_rime_r
rinser64317213_rinse_r
riper74328403_ripe_r
rise45945233_rise__
risen54621883_rise_n
risers64624783_risers
rises55244043_rise_s
risker105414493_risker
risque15227453_risque
risus54216393_ris_us
river85731693_rive_r
seiser65318343seise_r
sieur5911893_si_eur
trier54328533tri_e_r
trimer85717153trime_r
trisect939733trisect
triseme936543triseme
trismus935563trismus
triter65120593trite_r
upriser9218763uprise_r
wiser85522803_wise_r
wrier84521753wri_e_r
writer94416513write_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.856208751.2
2DLD Change Limit1340271427.16018718.9
3Display Results1421420.0433302.3
 (SQL Overall)1786911428.05922172.9
 
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.