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

39 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
modernises134473(None) 
modernise1244731modernise_
modernised1453401modernised
modernisms1543791modernisms
modernists1344291modernists
modernizes2244261modernizes
modernes1138422modern__es
modernism1444002modernis_m
modernist1246262modernis_t
modernities1444632modernities
modernize2144382modernize_
modernized2343732modernized
modernizer2243152modernizer
modernizers2352382modernizers
modernness1343522modernness
coderives1547483coder_ives
dermises112512023__dermises
derrises93012783__derrises
eternises9119453_eternises
exodermises2152623exodermises
maderizes2148953mader_izes
merises93421423m__er_ises
modelists1246473mode_lists
moderates12710753moder_ates
moderne1037123modern__e_
moderner1145523modern__er
modernest1248113modernes_t
modernising1543753modernising
modernistic1653013modernistic
modernity1543533moderni_ty
modernnesses1543863modernnesses
moderns1037963modern___s
modesties1247473modesti_es
monetises11311043mone_tises
moonrises1146723moonr_ises
moperies12313873moper_i_es
morrises10711073mo__rrises
mortises10713613mo__rtises
motorises11311673motor_ises

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.423422437.4
2DLD Change Limit140603395.61025062.9
3Display Results39390.0301300.0
 (SQL Overall)178691396.06329472.4
 
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.