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

63 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
redefining154542(None) 
predefining1844161predefining
defining133711802__defining
redeciding1544702redeciding
redefying1736092redef_ying
redesigning1443652redesigning
redlining111210292red_lining
refining122416862r__efining
bedeafening1852103bedeafening
bedeviling1743483bedeviling
beelining1236593be_elining
beneficing1843823beneficing
benefiting1644313benefiting
defiling132812463__defiling
deveining1436393deve_ining
medicining1643883medicining
misdefining1843313misdefining
predestining1654463predestining
reaffixing2442323reaffixing
rebeginning1541983rebeginning
receiving1538993rece_iving
reclining121112283re_clining
recoining121313803re_coining
reconfining1745113reconfining
redbaiting1446263redbaiting
reddening1237433red_dening
redeeming1337363rede_eming
redefeating1645333redefeating
redefecting1844373redefecting
redefine1238973redef__ine
redefined1445593redefin_ed
redefines1347413redefin_es
redemanding1643483redemanding
redenying1437783rede_nying
redividing1644193redividing
redlinings12132793red_linings
redonning11127643red_onning
redriving1437603red_riving
reearning1039053re_earning
reedifying1845243reedifying
reediting11310953re_editing
reefing114016863re_ef__ing
refiling123116533r__efiling
refinding14259943r__efinding
refiring123513923r__efiring
refixing19329793r__efixing
refraining1437263refraining
regaining112411083re_gaining
reining84425323r__e_ining
rejoining17149223re_joining
relearning1135283relearning
relining93218743r__elining
relumining1345643relumining
remaining122212793re_maining
repining114116593r__epining
replevining1743153replevining
rereminding1553783rereminding
reseizing19311233rese_izing
reshining13310743re_shining
resining92919553r__esining
retaining102114733re_taining
retraining11310243retraining
sidelining1244573sidelining

Search took 7 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 Filter1786911406030.406440125.6
2DLD Change Limit140603635.92023750.5
3Display Results63630.0331909.1
 (SQL Overall)178691636.35928100.5
 
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.