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

59 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
relocatee1181063(None) 
relocate10713531relocat_e
relocated12710811relocated
relocatees1275221relocatees
relocates11712931relocates
prelocate13109512prelocat_e
prelocated1597182prelocated
prelocates1468352prelocates
allocate10411023allocat_e
allocated1248093allocated
allocates11410473allocates
colocate12313433colocat_e
colocated1439613colocated
colocates13312853colocates
dedicatee13410343dedicatee
delegatee1148803delegatee
delicate11315493delicat_e
delicates12314313delicates
electee92513243_elec_tee
locate83919843__locat_e
located103114183__located
locater93113603__locater
locates93218813__locates
reallocate1254423reallocat_e
reallocated1443773reallocated
reallocates1354333reallocates
recoated113416783reco_ated
refloated1347013reflo_ated
rejectee17289623rejec_tee
relate64033633rel__at_e
related83327573rel__ated
relater73723143rel__ater
relates73731433rel__ates
relegate9311243relegat_e
relegated1139763relegated
relegates10310943relegates
reloaded1059103relo_aded
reloader937913relo_ader
reloaned939723relo_aned
relocatable1542863relocatable
relocating13310873relocating
relocation12312113relocation
relocked15217743reloc_ked
reluctate1146923reluctate
reluctated1345943reluctated
reluctates1246703reluctates
relucted1138653reluc_ted
renovate1138553renovat_e
renovated1347173renovated
renovates1248453renovates
replicate13410043replicat_e
replicated1548773replicated
replicates1449453replicates
resonate8513513resonat_e
resonated10510613resonated
resonates9412403resonates
revocable1647003revocable
selectee10910493selec_tee
unlocated1238383unlocated

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.453394461.4
2DLD Change Limit148641596.54622707.1
3Display Results59590.0301966.7
 (SQL Overall)178691597.02925422.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.