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

98 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
demireps134399(None) 
demirep1236211demirep_
bemires113212832bemire_s
demies94825802demi_e_s
demises103719562demise_s
desirers939262desirers
desires81316132desire_s
admirers1134713admirers
admires1038663admire_s
bemire103312803bemire__
bemired123410633bemire_d
bemixes18338653bemixe_s
deaired9411533deaire_d
deairs74013783deair__s
dearies83526273dearie_s
debriefs1433533debriefs
decares102818533decare_s
deciares11510633deciare_s
decibels1344523decibels
deciders123510753deciders
decides114217653decide_s
deciles104417723decile_s
decrees102513123de_crees
decriers11299733decriers
decries103319803decrie_s
deeps84921773de___eps
defiers113913993defi_ers
defies104624053defi_e_s
defilers12439473defilers
defiles114016843defile_s
definers124211193definers
defines114118683define_s
degrees92810723de_grees
deicers103612733de_icers
deices94119373de_ice_s
dekares122710873dekare_s
delimes10314193delime_s
delivers123310753delivers
demarks14339233demar_ks
demergers13146403demergers
demerges12129503demerges
demerits11310763demerits
demes86032693dem__e_s
demigods1343983demigods
demise94618323demise__
demised113613683demise_d
demisters1249203demisters
demits94918073demi__ts
demiurges1343873demiurges
demoness1138053demoness
demoses103815823demose_s
demotes104717673demote_s
demure9311533demure__
demurely1443933demurely
demurer1037873demure_r
demurest1137453demurest
demurrers1243713demurrers
demurs939773demur__s
deniers84515183deni_ers
denies74729643deni_e_s
denizens1835573denizens
depress10239873de_press
deriders102411853deriders
derides93420853deride_s
derivers123811363derivers
derives114017813derive_s
dermises112512023dermise_s
derries83124623derrie_s
desire7415303desire__
desired9311983desire_d
desirer8310783desire_r
desirous947783desirous
devices133212583device_s
devisees12358283devisees
devisers12339863devisers
devises114116763devise_s
dewdrops1542963dewdrops
dewiness1238453dewiness
dexies145018343dexi_e_s
domines102918973domine_s
emigres1037673_emigre_s
emirs76116163_emir__s
empires1139853_empire_s
empress1138163_empress
heiress1036813he_iress
lemures938793lemure_s
mires75640883__mire_s
refires104820313refire_s
rehires105016113rehire_s
remiges103015473remige_s
remises93423483remise_s
remixes164313873remixe_s
retirees84611653retirees
retirers84311533retirers
retires74726213retire_s
rewires104717113rewire_s
semises93916553semise_s
venires103012453venire_s

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.436409841.7
2DLD Change Limit146162986.51622431.2
3Display Results98980.0462130.4
 (SQL Overall)178691986.99825534.6
 
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.