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

92 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
inspiring124618(None) 
aspiring1138872_aspiring
conspiring1546552conspiring
inquiring19155642inquiring
insnaring1046312insnaring
insphering1644192insphering
inspirit1046282inspiri_t
inspiriting1443642inspiriting
inspirits1144252inspirits
insuring9311152ins_uring
reinspiring1443802reinspiring
respiring12159902respiring
spiring103918182__spiring
suspiring1245702suspiring
uninspiring1451952uninspiring
unsparing1237712unsparing
answering1345803answering
aspirin937823_aspirin_
aspirins1037733_aspirins
desiring10312143des_iring
despairing1445063despairing
despising13167503despising
despiting13179323despiting
enquiring19175443enquiring
ensiling9410723ens_iling
ensnaring1046383ensnaring
ensphering1644973ensphering
ensuring9310173ens_uring
expiring1836253_expiring
impairing1445473impairing
incising11411093in_cising
inciting11312533in_citing
inclining1248403inclining
incurring1236873incurring
inditing10312113in_diting
inferring1338613inferring
infirming1545163in_firming
infixing1936103in_fixing
inhering12913713in_hering
injuring1637473in_juring
inpouring1236393inpouring
inscribing1543853inscribing
inserting10914243inserting
insetting1079283insetting
inshrine1147493ins_hrine
inshrining14104583inshrining
insisting1038823insisting
insouling1036823insouling
inspanning1343203inspanning
inspecting1546223inspecting
inspire938253inspir__e
inspired1136273inspir_ed
inspirer1045183inspir_er
inspirers1143963inspirers
inspires1037623inspir_es
inspirited1343703inspirited
instarring1144063instarring
instating10812213instating
instilling1145803instilling
insulting1038053insulting
interring10315423interring
intuiting1089613intuiting
intwining1345883intwining
inuring81213013in__uring
inviting1239733in_viting
invoicing1545333invoicing
mainspring1553793mainsp_ring
misfiring1536973misfiring
perspiring1544853perspiring
respiting121912863respiting
respring111614063resp_ring
siring75128313__s_iring
sparing104823873__sparing
speiring113711263__speiring
spicing123914533__spicing
spiering112713353__spiering
spiking144312883__spiking
spiling102919703__spiling
spirting112913633__spirting
spiting103917623__spiting
sporing104319413__sporing
spring94526013__sp_ring
transpiring1446873transpiring
umpiring1336093_umpiring
unhairing1335953unhairing
unpiling1139753un_piling
unsmiling1256873unsmiling
unsphering1644283unsphering
unsprung1143173unsp_rung
unstring9312093uns_tring
untiring9312003un_tiring
upspring1335703upsp_ring

Search took 9 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.423422437.4
2DLD Change Limit148641927.57619620.0
3Display Results92920.0462000.0
 (SQL Overall)178691928.04522211.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.