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

51 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
squalider194384(None) 
equaliser1854482equaliser
equalizer2745752equalizer
squalid1737052squalid__
squalidest2043392squalidest
squalidly2242322squalidly
squaller1736082squal_ler
squallier1844362squallier
squander1835532squa_nder
equalise1748213equalise_
equalised1945473equalised
equalisers1942943equalisers
equalises1847253equalises
equalize2648023equalize_
equalized2846863equalized
equalizers2843983equalizers
equalizes2747693equalizes
quakier20239203_quaki_er
qualifier2145123_qualifier
qualmier1934563_qualmier
scalier94316913s_cali_er
shalier103116423s_hali_er
shoalier1137073shoali_er
slider73918363s___lider
solider82912453s__olider
squabbier2242753squabbier
squabbler2242733squabbler
squadded2033843squa_dded
squalene1745613squalene_
squalenes1845763squalenes
squalidness2141923squalidness
squalled1835943squal_led
squallers1834683squal_lers
squalor1644423squal__or
squanders1934443squa_nders
squarer163410663squa__rer
squasher20185783squa_sher
squashier2143913squashier
squatter1735913squa_tter
squattier1843713squattier
squawker2443093squa_wker
squeakier2242903squeaki_er
squealer17115603squeal__er
squelcher2342783squelcher
staider83912613s_ta_ider
stolider936603s_tolider
studlier935473studli_er
stupider1133913stu_pider
sublimer1237613s_ublimer
subsider1138243s_ubsider
surlier72915443s_urli_er

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.436409841.7
2DLD Change Limit148641517.15620771.5
3Display Results51510.0163187.5
 (SQL Overall)178691517.60823487.3
 
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.