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

93 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
insulters94588(None) 
insulter836881insulter_
consulters1297212consulters
indulgers1143802indulgers
inputters1143442inputters
inserters92210282inserters
insetters9187132insetters
insisters997652insisters
insulars8137322insul_ars
insulates9311842insulate_s
insulators1047262insulators
insulted937192insulte_d
insults7268962insult__s
insurers83710132insu_rers
assaulters1042463assaulters
consulter1198223consulter_
consultors1286403consultors
coulters103614313_coulters
desalters1037673desalters
ensurers8279373ensu_rers
imputers1235823impu_ters
incenters112510303incenters
inciters103210673in_citers
incumbers1544003incumbers
indenters102710033indenters
indicters1236733indicters
inditers93311053in_diters
inducers11326953indu_cers
inductees1244713inductees
inductors1246223inductors
indulger1044153indulger_
indulges1045263indulge_s
indults8289493indult__s
infecters14257583infecters
infesters12237713infesters
inflaters1247543inflaters
infolders1385173infolders
infusers11286143infu_sers
inhalers1166643inhal_ers
inhaulers1263243inhaul_ers
inholders1345353inholders
inhumers1364823inhu_mers
injurers15286123inju_rers
inliers73110743in__liers
inputter1034203inputter_
inquirers18234013inquirers
inselberg1241843inselberg
inselbergs1351233inselbergs
inserter82312133inserter_
insetter8218593insetter_
insiders947763ins_iders
insister888783insister_
insnarers954433insnarers
insolates9311273insolate_s
insoles73516243insol_e_s
inspirers1143963inspirers
installers1043633installers
instars7411133ins__tars
instates81615833instate_s
insteps936573ins__teps
instillers1043663instillers
insulants946913insulants
insular7138703insul_ar_
insulate8312843insulate__
insulated10310713insulate_d
insulator948103insulator_
insulins848863insul_ins
insult62813673insult___
insulting1038053insulting
insureds9277613insu_reds
insurer73312803insu_rer_
insures73117263insu_re_s
inters64328053in___ters
inventers12269533inventers
inverters12239753inverters
inviters11359643in_viters
involvers1544033involvers
issuers746123issu__ers
minsters103813923mins__ters
misalters1136913misalters
moulters103510783_moulters
neuters74212273_neu_ters
nutters74215433_n_utters
occulters1343453occulters
pinsetters1244103pinsetters
poulters103911053_poulters
psalters10227713_psalters
salters73622253__salters
suiters73618883__suiters
sulkers113613343__sulkers
sutlers73116973__sutlers
unsolders1064693unsolders
vaulters11206173_vaulters

Search took 8 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 Limit148641937.18620684.8
3Display Results93930.0462021.7
 (SQL Overall)178691937.65523343.0
 
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.