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

54 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
dipshits144526(None) 
dipshit1347991dipshit_
mishits122513082mi_shits
airships1347713airships
airshots1145943airshots
dashis104414393d_ashi_s
deposits1138843deposits
diapsids1244753diaps_ids
diesis74013493dies_i_s
dights114016963di_gh_ts
digits84114533di__gits
dimwits1344513di_mwits
dinghies1347363dinghies
diploids1247843diploids
diplonts1146473diplonts
dipnets10109033dip_nets
dipodies1238413dipodies
dipsades1246493dipsades
dipsas9359893dips__as
dipsos95310053dips__os
dipstick1775223dipstick
dipsticks1864213dipsticks
disherits1348233di_sherits
dishes104622653di_sh_es
dishier113613403di_shier
dishiest12313683di_shiest
dishing124017103di_shing
dismiss1038153di_smiss
disparts11109953disparts
dispirits1246143dispirits
disports111111113disports
disseats93211503disseats
dissects11279243dissects
dissents93411863dissents
disserts92411813disserts
distils83015803di_stils
dixits144210313di__xits
dropshots1543393dropshots
gipsies1039903gips_ies
hipshot15106643hipshot_
kinships1745793kinships
kipskins1343263kipskins
midships1645693midships
misfits12279663mi_sfits
mishit112618203mi_shit_
missuits1078023missuits
pipits104713063pip__its
rimshots1343883rimshots
rishis9312453ri_shi_s
shits84731173___shits
tipsheets1442223tipsheets
upshifts1642633_upshifts
upshots1235193_upshots
visits9311423vi_s_its

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 Filter1786911461620.420425454.8
2DLD Change Limit146162547.14320462.3
3Display Results54540.0134153.8
 (SQL Overall)178691547.57623586.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.