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

73 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
spoliating136696(None) 
foliating1339252_foliating
solating9315592s_ol_ating
solvating1336442s_olvating
speciating1548122speciating
splinting1238192sp_linting
splitting1236562sp_litting
spoliation1248422spoliation
spoliations1347692spoliations
associating1444863associating
bloviating1643813bloviating
collating12312763_collating
defoliating1645823defoliating
epilating12310963epil_ating
exfoliating2243393exfoliating
filiating1339243_filiating
isolating1039743isol_ating
opiating11410093__opiating
oppilating1544853oppilating
palliating1347883palliating
palpating1438533_palpating
plaiting113113513_p_laiting
plating103823073_p_l_ating
pleating112916053_p_leating
pointing112813683_po_inting
poleaxing1944873_poleaxing
policing13311673_poli_cing
polishing1536923_polishing
polkaing1534633_polka_ing
pollinating1445613_pollinating
polluting1235703_polluting
positing11312303_posi_ting
pulsating1236343_pulsating
salivating1447433s_alivating
satiating10311803s_atiating
sealifting1444633sealifting
seriating10916403s_eriating
shoplifting2052143shoplifting
sibilating1346963sibilating
slating83724653s__l_ating
slitting93012583s__litting
solacing11310133s_ol_acing
soliciting1346813s_oliciting
sonicating1348313s_onicating
sopiting11310763s_opi_ting
spectating1546623spectating
spiriting1238413spiri_ting
spirting112913633sp__irting
spiting103917623sp__i_ting
spitting113012323sp__itting
splatting1235983sp_latting
splaying14219303sp_l_aying
splicing1338963sp_li_cing
splining11310773sp_li_ning
spoiling112911553spo_i_ling
spoliate1039243spoliat__e
spoliated1246913spoliat_ed
spoliates1138543spoliat_es
spoliator1144843spoliat_or
spoliators1244823spoliators
sporting112415463spo__rting
sporulating1445113sporulating
spotlighting1951583spotlighting
spotting112812093spo__tting
spouting113511953spo__uting
sprinting12310033sp_rinting
striating10914193s_triating
sublating12310983subl_ating
sublimating1675463sublimating
sulfating1338063s_ulfating
supplicating1953743supplicating
uplifting1534963up_lifting
violating1337433viol_ating

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.406440125.6
2DLD Change Limit140603736.34322166.6
3Display Results73730.0302433.3
 (SQL Overall)178691736.77926359.5
 
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.