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 “farmer” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

143 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
farmer11501737(None) 
armer76924441_armer
farcer115016081farcer
farer86733141far_er
farmed125117651farmed
farmers124315261farmers
firmer114712441firmer
former114221401former
framer114817441framer
harmer114719551harmer
warmer113816731warmer
aimer75926822_aimer
armed86324432_armed
armers85520272_armers
armet76739452_armet
armor75118052_armor
barber104419322barber
barer74535802bar_er
barker124822862barker
barmen105418532barmen
barmier114313042barmier
barter85525372barter
calmer105216932calmer
carder94524182carder
career85822242career
carer74942332car_er
carmen104019342carmen
carper104923632carper
carter84932272carter
carver114420142carver
charmer144913662charmer
dammer114317932dammer
darer65230792dar_er
darker114718692darker
darner74017302darner
darter75320362darter
dormer94415892dormer
earner63617222earner
fabber134814112fabber
fabler116115812fabler
facer105525052fa_cer
fader94421512fa_der
fainer94717242fainer
fairer95212062fairer
fakeer13378742fakeer
faker124824592fa_ker
faller94621232faller
falser93912412falser
falter94519052falter
fame95639392fa_me_
famed115928342fa_med
fames105735922fa_mes
fanner94218182fanner
farce104925322farce_
farced125216532farced
farcers124713442farcers
farces115223322farces
farceur12525272farceur
farded114518952farded
fardel104712592fardel
fare76354462far_e_
fared95842342far_ed
farers95924052far_ers
fares85852872far_es
farfel124310432farfel
farle86929242farle_
farles96025782farles
farm95934532farm__
farms106324952farm_s
farrier103514882farrier
farted105121782farted
farther1348342farther
faster94625772faster
father125116712father
fatter94523212fatter
fawner125910462fawner
fearer94820182fear_er
filmer114112402filmer
firer811229252fir_er
firmed125411882firmed
firmers124711442firmers
flamer114919122flamer
foamer114714312foamer
forcer114917342forcer
forger104820762forger
forker134717902forker
forme105225992forme_
formed125021172formed
formee113919942formee
formers128217952formers
formes114623712formes
frame105821802frame_
framed125116522framed
framers125113822framers
frames115119862frames
frater94520592frater
freer86021242f_reer
frier85225842f_rier
fryer115913432f_ryer
fumer105918232f_umer
furler93616402furler
gamer84928942ga_mer
gammer1112318332gammer
garner73917002garner
garter74420512garter
hammer138120032hammer
harder105022402harder
harmed125218832harmed
harmers124116592harmers
harper115018402harper
jammer174014132jammer
lamer75233702la_mer
larder73720972larder
larger74417512larger
larker104519242larker
maimer104514592maimer
mammer94218862mammer
marker124420392marker
marrer83716672marrer
namer75622102na_mer
ormer75218372_ormer
palmer105816542palmer
parer75839902par_er
parker124121372parker
parser84822372parser
rammer103519652rammer
rarer54731702rar_er
swarmer1247802swarmer
tamer75230102ta_mer
tarter64023562tarter
termer85717252termer
varier94619352varier
warder104020272warder
warier93722892warier
warmed124516892warmed
warmers124514292warmers
warner93717222warner
warper114015582warper
wormer114514912wormer
yammer133713182yammer
yarder103813972yarder
yarer84321572yar_er
yarner93313062yarner

Search took 4 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 Filter178691825510.1701051123.5
2DLD Change Limit825511433.17326016.7
3Display Results1431430.0334333.3
 (SQL Overall)1786911433.37652929.8
 
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.