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 “reference” 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
reference1481009(None) 
deference1578491deference
preference1776981preference
referenced1676861referenced
references1589351references
reverence14710161reverence
deferences1677872deferences
inference14411022inference
preferences1876182preferences
refence12312232ref__ence
referee101615752refere__e
referenda1343072referenda
referent112813422referen_t
referents12259642referents
refluence1445852refluence
reverenced1676312reverenced
reverencer1575722reverencer
reverences1579172reverences
adherence1564893adherence
coherence1676933coherence
conference1799003conference
defence1339893def__ence
deferent122712873deferen_t
deferents13269393deferents
deterrence1345623deterrence
difference1955023difference
emergence14136613_emergence
inferences15410343inferences
inherence1449263inherence
irreverence1653103irreverence
misreference1982523misreference
precedence1746113precedence
recreance1346993recreance
recurrence1445313recurrence
redolence1256763redolence
reemergence1653163reemergence
reerect92915883re_ere_ct
refenced1438993ref__enced
refences13311843ref__ences
referable1439623referable
refereed12149693refere_ed
referees111310413refere_es
referencing1744493referencing
referendum1661613referendum
refinance14117643refinance
refluences1545513refluences
refreeze2063263ref_reeze
refulgence1653613refulgence
relevance14146433relevance
remanence1346713remanence
renitence1149053renitence
resentence1248113resentence
reservice1445263reservice
residence1268903residence
resurgence1345493resurgence
reticence1347623reticence
retrench1346283re_trench
reverencers1673323reverencers
reverend12288853reveren_d
reverends13266033reverends
reverent112615093reveren_t
severance1447323severance
vehemence1943603vehemence

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 Filter1786911486410.423422437.4
2DLD Change Limit148641637.23620541.9
3Display Results63630.0302100.0
 (SQL Overall)178691637.68923239.8
 
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.