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

152 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
harem10492445(None) 
haem95730981ha_em
hare76255731hare_
hared95742181hared
hareem114312061hareem
harems115513821harems
hares86255541hares
harm95637791har_m
ahem97225362_ahem
are37874572_are_
area45843392_area
ares45871022_ares
arm58449622_ar_m
arum66129032_arum
bare65460522bare_
bared85144482bared
barer74535802barer
bares75457132bares
barm86739602bar_m
care66968372care_
cared86050092cared
carer74942332carer
cares77369182cares
caret75360562caret
carex144822292carex
carom95025562carom
chare105231982chare_
chared125423692chared
chares115631802chares
charm126124662char_m
dare55848862dare_
dared75935012dared
darer65230792darer
dares66146702dares
eared65139502eared
fare76354462fare_
fared95842342fared
farer86733142farer
fares85852872fares
farm95934532far_m
hacek145411842hacek
hade85440192hade_
haded105227622haded
hades96035112hades
hae67364002ha_e_
haed86338582ha_ed
haems105517012ha_ems
haen76229452ha_en
haeres94017032haeres
haes77651022ha_es
haet75659502ha_et
haired105117172haired
hajes155420942hajes
hake115637842hake_
hakeem15407382hakeem
hakes126034302hakes
hakim14311822hakim
hale76052832hale_
haled95335822haled
haler85033522haler
hales85449842hales
halm95834972ha_lm
ham86363282ha__m
hame97043132hame_
hames106138702hames
hard85443502har_d
harden105718532harden
harder105022402harder
hards96435652hards
hardy125622062hardy
hareems12428202hareems
hark115237392har_k
harked145422552harked
harken135116342harken
harks126333432harks
harl75740002har_l
harls85634502harls
harmed125218832harmed
harmer114719552harmer
harms106829012harms
harp96134282har_p
harped124418402harped
harper115018402harper
harps105926862harps
harpy136418202harpy
harry115322952harry
harsh116418052harsh
hart76865772har_t
harts88441592harts
hate78450172hate_
hated95734022hated
hater85034752hater
hates86742572hates
hatred104814332hatred
haulm104415412haulm
have106137072have_
haven114718532haven
haver115124462haver
haves116034872haves
hawed126025422hawed
hayed125822012hayed
hayer114620242hayer
hayey144812532hayey
haze164833392haze_
hazed185222202hazed
hazel176414812hazel
hazer174820232hazer
hazes174928322hazes
hearer94323642hearer
hem86148732h__em
here76447102here_
heres86245902heres
herm95636152her_m
hire75538962hire_
hired95226262hired
hiree85427802hiree
hirer85423122hirer
hires86134342hires
laree56036292laree
lares54852632lares
larum74317972larum
mare64759322mare_
mares76457632mares
nares55544152nares
oared65030652oared
pare66760842pare_
pared86946762pared
pareo74632602pareo
parer75839902parer
pares77164482pares
pareu74928742pareu
rare45348432rare_
rared65738322rared
rarer54731702rarer
rares55247442rares
rem56150042__rem
saree55044662saree
satem76021452satem
share86437082share_
shared105829062shared
sharer95025482sharer
shares95236412shares
tare45957622tare_
tared69340052tared
tares57456562tares
tharm105916642thar_m
ware76254722ware_
wared96339872wared
wares88250582wares
warm95935672war_m
yare75636942yare_
yarer84321572yarer

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit538001521.70331591.3
3Display Results1521520.0334606.1
 (SQL Overall)1786911521.82997698.7
 
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.