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 “displosions” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

104 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
displosions1420383(None) 
displosion13184491displosion_
dispassions1453882dispassions
dispersions1446452dispersions
implosions1444022_implosions
diplosis11128413di_plosi__s
disclosing1446613disclosi_ng
discussions1444243discussions
disillusions1352323disillusions
dismissions1454003dismissions
dispassion1344323dispassion_
dispersion1346863dispersion_
disploding1575873displodi_ng
disposing1339933disp_osi_ng
dispositions1546473disp_ositions
dissensions12175573dissensions
dissuasions1243523dissuasions
distensions12146273distensions
divulsions1443343divul_sions
explosions19134663_explosions
implosion1344343_implosion_
misprisions1553153misprisions
plosions1038023___plosions
aspersions1246104_aspersions
cisplatins1444594cisplati_ns
delusions1037054d__elusions
depletions1355744d_epletions
descensions1444374descensions
desolations12310594desolations
diapasons1243204diap_as_ons
diffusions1743734di_ffusions
digressions1344744digressions
dilations102614454di__lations
dilutions10248584di__lutions
diluvions13224444di__luvions
dimensions1344614di_mensions
diploids1247844di_plo_i_ds
diplopias1444774di_plopi_as
diplopods1543414di_plo_pods
diploses111110324di_plos__es
disbosoms1444064dis_bos_oms
disclosers1375194disclos_ers
discloses1249474disclos__es
disclosures1453104disclosures
discretions1447224discretions
discussion1344504discussion_
disillusion1252394disillusion_
disjoins1647624dis_jo_i_ns
dislimns1144814dis_l__imns
dislocations15136984dis_locations
dismission1354364dismission_
dispensations1655484dispensations
dispensing1448234dispensi_ng
dispersing1449304dispersi_ng
dispersoids1553014dispersoids
displacing1646414displaci_ng
displaying1746314displayi_ng
displeasing1544934displeasi_ng
displodes1347864displo__des
displuming1644374displumi_ng
disposals1245894disp_os_als
disposers1238374disp_os_ers
disposes11313824disp_os__es
disposition1446684disp_osition_
dispossess1243394disp_ossess
disposures1344764disp_osures
disproofs1544634dispro__ofs
disproving1746294disprovi_ng
disputations15106174disputations
disrelations1348504disrelations
disruptions14125684disruptions
dissections14198264dissections
disseisins1145954disseisi_ns
dissension11135724dissension_
dissentions12168044dissentions
dissolutions13144924dissolutions
dissuasion1143844dissuasion_
distension11156274distension_
distentions12178844distentions
distortions1246614distortions
disulfotons1551054disulfotons
disunions1055974dis__unions
diversions1446534di_versions
divisions1396284di__visions
divulsion1343554divul_sion_
dysplasias1653224dysplasi_as
dysprosiums1951214dysprosiums
eclosions1146204__eclosions
explosion18115214_explosion_
fissions1138034fis___sions
illusions946214_i_llusions
impassions1444844_impassions
impletions1445004_impletions
implosives1743054_implosives
impulsions1443604_impulsions
inclusions1275654_inclusions
isolations10310694_isolations
mispositions1655304misp_ositions
misprision1453504misprision_
missions10311904mis___sions
plosion939114___plosion_
responsions1363774responsions
sponsions1145224__sponsions
suspensions1353844suspensions

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 Filter1786911488190.406440125.6
2DLD Change Limit1488191048.78316944.0
3Display Results1041040.0601733.3
 (SQL Overall)1786911049.24919320.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.