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

144 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
reconfer133767(None) 
reconfers1437211reconfers
confer114018682__confer
recanter101913152recanter
recenter102715442recenter
reckoner1446062reckon_er
recoiler103210492recoiler
reconfirm1643812reconfirm
reconned113610652reconned
reconquer2084072reconquer
reconvert1449472reconvert
reconvey1655602reconvey
recorder11249632recorder
recounter1137942recounter
recover124312622reco_ver
reoffer1335012re_offer
seconder1137182seconder
beckoner1654963beckon_er
coffer144112863__coffer
coinfer12419393__coinfer
confers124120093__confers
conger95024273__conger
conifer123212643__conifer
conker124721553__conker
conner84423963__conner
deboner103110483debon_er
decanter112510793decanter
decenter112412163decenter
decoder113712293deco_der
decoyer13348683deco_yer
feoffer1233023fe_offer
precancer1547093precancer
preconcert16147973preconcert
precooker1744123precooker
raconteur1141993raconteur
reasoner849343reason_er
rebounder1245103rebounder
recaller1039323recaller
recamier1237603recamier
recane83022873recan_e_
recaned102817203recan_ed
recanes93222263recan_es
recanted112513513recanted
recanters112310483recanters
receiver1337413receiver
recensor1045543recensor
reciter94117263rec_iter
reckoned1546953reckon_ed
reckoners1545113reckon_ers
recliner103211913recliner
recoaled113111783recoaled
recoated113416783recoated
recocked17248473recocked
recode93618713reco_de_
recoded113115033reco_ded
recodes102918633reco_des
recognizer2254453recognizer
recoiled113613213recoiled
recoilers11318153recoilers
recoined113614423recoined
recolor978693reco_lor
recombed1536713recombed
recon75624243recon___
reconciler1444693reconciler
reconferred1783663reconferred
reconfine1448013reconfine
reconfined1645683reconfined
reconfines1546653reconfines
reconfirms1743133reconfirms
reconnect1347043reconnect
reconquers2193353reconquers
recons84922993recon__s
reconsider1344533reconsider
recontour1143713recontour
reconvene1446493reconvene
reconverts1545723reconverts
reconveys1743533reconveys
recooked15268243recooked
recopied1339843recopied
recopies12313733recopies
recorded122511063recorded
recorders12187953recorders
recorked15239853recorked
recounted1238713recounted
recounters1246213recounters
recoupe11109933recoupe_
recouped13128663recouped
recoverer14134973recoverer
recovers133511123reco_vers
recovery16366213reco_very
rectifier1457733rectifier
recycler1543683recycler
redone74820053redon_e_
redonned10297103redonned
reefer93314363re__efer
reenter73217793re_enter
refer84822143re___fer
refiner105316913refin_er
reformer13217953reformer
refunder1236503refunder
reinter73116843re_inter
rejoicer17315343rejoicer
rejoinder1743713rejoinder
reloader937913reloader
reminder113110513reminder
remoter94815973remo_ter
remover124612273remo_ver
rencontre1144163rencontre
rencounter1244293rencounter
render74024143re__nder
renouncer1145843renouncer
renter64527413re__nter
reoffers1434693re_offers
reorder8239483re_order
repenter102813863repenter
repiner94816903repin_er
reporter10411423reporter
reposer93715333repo_ser
repower12329883repo_wer
reroller8258753reroller
reroofed1235873reroofed
rescinder1245293rescinder
resolder9259233resolder
resolver11339793resolver
resorter8312183resorter
responder1246453responder
retorter8410733retorter
revenger1237303revenger
revenuer1136893revenuer
revoker14419193revo_ker
revolter11279363revolter
revolver14287713revolver
rewinder12317663rewinder
rezone153814783rezon_e_
rezoned173611163rezon_ed
rezones163213943rezon_es
rolfer94412273r__olfer
roofer94415283r__oofer
scoffer15317023_scoffer
seconde1037413seconde_
seconded1236353seconded
seconders1236953seconders
secondes1138133secondes
tenoner739683tenon_er

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.420425454.8
2DLD Change Limit1461621447.34619896.8
3Display Results1441440.0602400.0
 (SQL Overall)1786911447.82622833.0
 
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.