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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

59 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
specialising175401(None) 
specializing2655501specializing
serialising12167002s_erialising
socialising1445642s_ocialising
penalising1347623_pe_nalising
serializing21149403s_erializing
socializing2347343s_ocializing
specialise1446603specialis__e
specialised1654533specialis_ed
specialises1546003specialis_es
specialism1646813specialis__m
specialisms1745973specialis_ms
specialist1448343specialis__t
specialistic1854183specialistic
specialists1546203specialis_ts
specialities1656793specialities
speciating1548123specia__ting
sterilising1245023steri_lising
decimalizing2755964_decimalizing
equalising2065994__equalising
focalising1645624_foc_alising
grecianizing2553414grecianizing
idealising1245704ide__alising
legalising1245744_le_galising
localising1345974_loc_alising
materialising16114494materialising
metalising1348944_me_talising
musicalising1753014musicalising
penalizing2249924_pe_nalizing
racializing2347804_racializing
radicalising1653604radicalising
realising10313174_re__alising
revitalising1654664_revitalising
sacralizing2347404s_acralizing
scandalising1653254scandalising
secularising1553834s_ecularising
sexualizing2846084s_exualizing
signalising1344164s_ignalising
specialest1445574speciales__t
specialisation18182754specialisation
specialisations19132424specialisations
speciality1746334special__ity
specialize2347194special__ize
specialized2545844speciali_zed
specializes2446444speciali_zes
specials1238034special_s___
specialties1544664special_ties
speciation1449394speciati_on_
speciations1548484speciati_ons
specifying2144684speci__fying
speckling18235584spec_kl__ing
spectating1546624specta__ting
speculating1645944spec_ulating
speiling113612974spe_i_l__ing
stabilising14134114stabi_lising
sterilizing2146904steri_lizing
subspecializing3181944subspecializing
trivialising1673074trivialising
vocalising1645524_voc_alising

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 Filter1786911247900.453394461.4
2DLD Change Limit124790596.65318757.0
3Display Results59590.0331787.9
 (SQL Overall)178691597.13925030.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.