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

101 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
returners937655(None) 
returnees9396111returnees
returner8397981returner_
retainers92510762retainers
retarders10227572retarders
retirers84311532retir_ers
retorters938772retorters
retunes76918402retu_ne_s
returned9459132returne_d
returnee8449882returne_e
returns79712592return__s
roturiers944552roturiers
turners73912892__turners
burners94115673__burners
churners13316893_churners
dehorners1344743dehorners
demurrers1243713demurrers
detainers10269103detainers
detergers11147183detergers
deterrers10116593deterrers
dethroners1443633dethroners
earners74016453_e_arners
gesturers1044283gestur_ers
jetliners1644183jetliners
learners8398153le_arners
lecturers11124233lectur_ers
maturers1037373matur_ers
mourners1036913_mourners
perturbers1442633perturbers
ratooners965833ratooners
ratteners9237263ratteners
rearers74323563re_ar_ers
reasoners947113reasoners
rebukers14435683rebu_kers
reburies10311143reburie_s
rebutters1195093rebutters
reckoners1545113reckoners
recliners11279113recliners
recorders12187953recorders
recurves1337403recurve_s
redliners10267853redliners
reducers1147263redu_cers
referrers12125373referrers
refiners114713313re_finers
reformers14246403reformers
refunders1334973refunders
refusers11499273refu_sers
refuters11449613refu_ters
regainers10237383regainers
remarkers15197283remarkers
renumbers1344123renumbers
reorders9198833re_orders
repiners103913433re_piners
reporters1139173reporters
repulsers1144713repulsers
requirers18165003requirers
requiters18176553requiters
reservers12138103reservers
resigners1036863resigners
resorters939683resorters
restorers95110113restor_ers
resumers1038083resu_mers
resurges9310123resurge_s
resurveys1542683resurveys
retailers9258773retailers
retainer82913813retainer_
retakers123511133ret_akers
retarder9229433retarder_
retargets1045303retargets
retempers1345023retempers
retenes76324623ret_ene_s
rethinkers1743023rethinkers
retines75134673ret_ine_s
retirees84611653retir_ees
retirer74715013retir_er_
retires74726213retir_e_s
retorter8410733retorter_
retouchers1543483retouchers
retracers11149553retracers
retries74129073ret_rie_s
retune69121953retu_ne__
retuned86613973retu_ne_d
return623222523return___
returning1038133returning
reutters8138573re_utters
reverers113113153rever_ers
reversers12298483reversers
reverters122710433reverters
rewarders13226453rewarders
roturier836033roturier_
ruiners74213023r__uiners
runners74212453r__unners
securers1057153secur_ers
spurners10288493_spurners
stunners8277923_stunners
tuners64417343__tu_ners
turner63914613__turner_
turnery10357423__turnery
venturers1245523ventur_ers
westerners1344463westerners
yearners11346373ye_arners

Search took 9 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 Filter1786911486410.1731032896.0
2DLD Change Limit1486411018.51317460.5
3Display Results1011010.0502020.0
 (SQL Overall)1786911018.73620454.6
 
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.