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

129 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
returner839798(None) 
returned9459131returned
returnee8449881returnee
returners9376551returners
retainer82913812retainer
retarder9229432retarder
retirer74715012retir_er
retorter8410732retorter
retune69121952retu_ne_
retuned86613972retu_ned
retunes76918402retu_nes
return623222522return__
returnees9396112returnees
returns79712592return_s
roturier836032roturier
turner63914612__turner
burner83819203__burner
churner12298343_churner
dehorner1235523dehorner
demurer1037873demur_er
demurrer1144043demurrer
detainer92910793detainer
deterger10147593deterger
deterrer9137013deterrer
dethroner1344483dethroner
earner63617223_e_arner
eterne6311723_eterne_
gesturer935983gestur_er
inturned9268313inturned
jetliner1534853jetliner
learner7319383le_arner
lecturer10136023lectur_er
maturer938973matur_er
mourner938083_mourner
perturber1343153perturber
ratooner886993ratooner
rattener8238533rattener
rearer64928913re_ar_er
reasoner849343reasoner
rebuker13407843rebu_ker
reburied1137913reburied
reburies10311143reburies
rebutter10106273rebutter
reckoner1446063reckoner
recliner103211913recliner
recorder11249633recorder
recurred1137093recurred
recurve1237403recurve_
recurved1436493recurved
recurves1337403recurves
redliner93510473redliner
reducer1059003redu_cer
reearned948883reearned
referrer11136053referrer
refiner105316913re_finer
reformer13217953reformer
refunder1236503refunder
refuser104912783refu_ser
refuter104312193refu_ter
regainer9249353regainer
remarker14178493remarker
renumber1244243renumber
reorder8239483re_order
repiner94816903re_piner
reporter10411423reporter
repugned1235353repugned
repulser1035803repulser
requirer17156113requirer
requiter17168643requiter
reserver11119633reserver
resigner937793resigner
resorter8312173resorter
restorer84813723restor_er
resumer9410113resu_mer
resurge839073resurge_
resurged1038623resurged
resurges9310123resurges
resurvey1444823resurvey
retailer82911573retailer
retained93016093retained
retainers92510763retainers
retaker113714313ret_aker
retarded102410753retarded
retarders10227573retarders
retarget9312743retarget
retemper1235183retemper
retene69224273ret_ene_
retenes76324623ret_enes
rethinker1643613rethinker
retine66237333ret_ine_
retines75134673ret_ines
retire64927013retir_e_
retired84620143retir_ed
retiree75019083retir_ee
retirees84611653retirees
retirers84311533retir_ers
retires74726213retir_es
retore67630763retor_e_
retorn610923423retorn__
retorted9312333retorted
retorters938773retorters
retoucher1444533retoucher
retracer101411883retracer
retried84419153ret_ried
retries74129073ret_ries
returning1038133returning
retuse66617223retu_se_
reutter71010093re_utter
reverer103815833rever_er
reverser113010483reverser
reverter114812873reverter
rewarder12208233rewarder
rottener8216973rottener
roturiers944553roturiers
ruiner64013643r__uiner
runner63814463r__unner
securer958253secur_er
spurner9269653_spurner
sterner7411913_sterner
stunner7349193_stunner
tuner56022683__tu_ner
turned73914473__turned
turners73912893__turners
turnery10357423__turnery
unturned9228563unturned
upturned11214013upturned
venturer1137243ventur_er
westerner1244953westerner
yearner10336873ye_arner

Search took 10 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.1561145455.1
2DLD Change Limit1461621298.98616265.5
3Display Results1291290.0462804.3
 (SQL Overall)1786911299.18819448.3
 
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.