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

49 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
steapsins114463(None) 
steapsin1044711steapsin_
stearins8312142stea_rins
stepsons1045662ste_psons
erepsins1037443ere_psins
pepsins11310433_pe_psins
sasins64923103s__a_sins
sealskins1343253s_ealskins
seasons72614233s_ea_sons
seisins73614393s_e_isins
sepsis83011293s_e_psi_s
sheepskins1951943sheepskins
skepsis1344253ske_psi_s
sneaping11349493sneap_ing
stains64923653st_a__ins
stapling112813153st_apling
stasis63116873st_a_si_s
statins73719773st_a_tins
steadies9311123stea_dies
steading103613593stea_ding
steadings11307083stea_dings
steadying14154503steadying
stealing93416603stea_ling
stealings10318853stea_lings
steaming114013213stea_ming
steamships1754063steamships
stearin7312003stea_rin_
stearine8311903stea_rine
stearines9311283stea_rines
steepens10277113steep_ens
steeping113412583steep_ing
steins64818343ste___ins
stemsons1045003ste_msons
stenosis847993stenosi_s
stepping13329073ste_pping
stepson945673ste_pson_
sternsons944663sternsons
stetsons845623ste_tsons
stewpans1343713stewp_ans
strains74218153stra__ins
strapping1436993strapping
strappings1543353strappings
stypsis1245243st_ypsi_s
synapsids1543223synapsids
synapsing1583483synapsing
synapsis1345143synapsi_s
teasing83918513_tea_sing
tenpins9410073_tenp_ins
trypsins1344903_trypsins

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 Limit148641497.06321045.0
3Display Results49490.0133769.2
 (SQL Overall)178691497.49923828.6
 
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.