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

53 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
itemizing214627(None) 
itemising1245881itemising
atomizing2148502atomizing
iteming1037752item__ing
agenizing2046333agenizing
atomising1247983atomising
bemiring13239603_bemiring
bemixing20226523_bemixing
bromizing2346583bromizing
demising122012523_demising
dimerizing2346773dimerizing
elegizing2045613elegizing
epitomizing2554493epitomizing
eternizing2046763eternizing
etherizing2346853etherizing
fiberizing2545043fiberizing
grecizing2235723grecizing
idealizing2147283idealizing
idolizing2046453idolizing
immixing2043543i_mmixing
intermixing2146613intermixing
iodizing1936673i_odizing
ionizing1839503i_onizing
ironizing1947933ironizing
itemize18106153itemiz__e
itemized20105333itemiz_ed
itemizer19104453itemiz_er
itemizers20133293itemizers
itemizes19106023itemiz_es
iterating10314253iterating
laterizing2049083laterizing
minimizing2445553minimizing
obelizing2146603obelizing
optimizing2445253optimizing
poetizing2148683poetizing
polemizing2446913polemizing
premising14412413premising
premixing2157803premixing
racemizing2445273racemizing
remising112516453_remising
remixing182810333_remixing
resizing182714163_resizing
seizing174114833_se_izing
stemming13408203stem_ming
stylizing2246303stylizing
stymieing1542593stymieing
systemizing2654223systemizing
temping122710693_tem_ping
tempting1357343_tempting
utilizing1947793utilizing
victimizing2853633victimizing
vitalizing2348353vitalizing
winterizing2446043winterizing

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 Filter1786911486410.1561145455.1
2DLD Change Limit148641539.01616486.4
3Display Results53530.0301766.7
 (SQL Overall)178691539.20219418.7
 
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.