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

52 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
definiens134530(None) 
deficient1547022deficient
deficients1644322deficients
definers124211192defin_ers
defines114118682defin_e_s
definienda1551852definienda
defining133711802defini_ng
befingers1544103befingers
decisions1248383decisions
defences1439633defence_s
defenders1436363defenders
defenses1237913defense_s
defiances1557033defiance_s
deficiency2153113deficiency
deficits1447283defici_ts
defiers113913993def__iers
defies104624053def__ie_s
defilers12439473defi_lers
defiles114016843defi_le_s
defiling132812463defili_ng
define104718143defin_e__
defined123813823defin_e_d
definement1648063definement
definements1747113definements
definer114413773defin_e_r
definiendum1861263definiendum
definientia1552653definientia
definite1239333defini_te
definitely1753193definitely
definiteness16105043definiteness
definitions1545603definitions
deftness1236303deftn_ess
deifiers12348993de_ifiers
deifies113317453de_ifie_s
deities82621923de_itie_s
deniers84515183de__niers
denies74729643de__nie_s
denizens1835573deni_zens
deringers1137183deringers
derisions1038843derisions
desinent9312963desin_ent
destinies10410843destinie_s
detinues9569823detinue_s
dewiness1238453dewin_ess
dominies113513193dominie_s
dominions12126553dominions
feminines14218173feminines
heinies102514543he_inie_s
meinies92516073me_inie_s
refiners114713313refin_ers
refines105426343refin_e_s
refining122416863refini_ng

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.420425454.8
2DLD Change Limit148641526.97021325.8
3Display Results52520.0163250.0
 (SQL Overall)178691527.40624127.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.