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 “rightsizing” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

34 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
rightsizing255208(None) 
digitizing2245353digit_izing
hightailing1951983hightailing
righting132610853right___ing
rightsize2243653rightsiz__e
rightsized2452793rightsiz_ed
rightsizes2353433rightsiz_es
sightseeing1651653sightseeing
agatizing2087464_agat_izing
bighting15269454bight___ing
brightening18102574bright_ening
cicatrizing2553904cicatrizing
dighting142510844dight___ing
digitalizing2454844digitalizing
emphasizing2853404emphasizing
fighting162710084fight___ing
fishtailing1851994fishtailing
frightening1982684fright_ening
frighting1736024fright___ing
highting16259724hight___ing
lightening15255054light_ening
lightering15246114light_ering
lighting132811834light___ing
lightning14286024light__ning
privatizing2645304privat_izing
resizing182714164r___esizing
rhythmizing3252344rhythmizing
ritualizing2156804ritualizing
robotizing2245554robot_izing
ruggedizing2451464ruggedizing
sighting133110864sight___ing
signalizing2245964signalizing
tightening15153944tight_ening
trichinizing2752574trichinizing

Search took 10 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 Filter1786911488190.1731032896.0
2DLD Change Limit148819348.93616653.9
3Display Results34340.0162125.0
 (SQL Overall)178691349.12519582.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.