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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

99 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
reef74938211re_ef
resee54336331resee
reset55051861reset
resew84519501resew
beef96233682be_ef
beses75830722beses
beset76739132beset
desex13311982desex
erses55826802erses
eses45336102_eses
keef115830012ke_ef
leses54930812leses
prese75228382prese_
preset84430982preset
rase46149982rase_
rased65033932rased
raser55633412raser
rases55447212rases
rebec94416542rebec
rebel73421292rebel
rede55037682rede_
reded74829122reded
redefy13388762redefy
redes65139132redes
ree37974072re_e_
reed55549622re_ed
reefs85121662re_efs
reefy114217702re_efy
reek85232522re_ek
reel45240532re_el
rees45364192re_es
reest54938092reest
ref66053292r__ef
refed93921922refed
refel84920812refel
refer84822142refer
reges65628792reges
rehem103815352rehem
reif76937652re_if
rekey124014732rekey
relet54749822relet
relief94419682relief
remet74843722remet
remex146315792remex
renew83917512renew
repeg84015052repeg
repel74921402repel
res35565042res__
resat55139682resat
resaw84117252resaw
resay85320542resay
reseal64819652reseal
reseat64131492reseat
reseau64216212reseau
resect84424702resect
reseda739702reseda
reseed74823292reseed
reseek103813132reseek
reseen64318412reseen
resees63827482resees
resell64215202resell
resend75016772resend
resent63833622resent
resets65427612resets
resewn9459812resewn
resews94814172resews
resh76523452res_h
reshes94124362reshes
resid64124092resid
resift94017722resift
resin54131052resin
resit54241042resit
resod64720052resod
resow88217242resow
rest46459842res_t
rested74430782rested
rester63832432rester
rests54935872rests
rete44944132rete_
retem74221952retem
reuse56025362reuse_
reused75419562reused
reuses66025522reuses
revel84423162revel
revet84938842revet
rewed95425452rewed
rewet85135152rewet
rexes124526952rexes
rise45945242rise_
risen54621882risen
riser55431052riser
rises55244042rises
rose46148902rose_
rosed65930352rosed
roses56445772roses
roset55945242roset
ruse45938932ruse_
ruses56136582ruses
yeses85119322yeses

Search took 3 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.296603685.8
2DLD Change Limit53800991.98627089.6
3Display Results99990.0303300.0
 (SQL Overall)178691992.31277288.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.