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 “ruralising” 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
ruralising114644(None) 
ruralizing2047881ruralizing
brutalising1444072brutalising
moralising1347622moralising
realising10313172r_ealising
reraising10313772rera_ising
alkalising1545013alkalising
braising113014563_bra_ising
brutalizing2365523brutalizing
canalising1349363canalising
curarizing2247103curarizing
dualizing2047783du_alizing
equalising2065993equalising
faradising1545273faradising
finalising1446673finalising
focalising1645623focalising
formalising1754863formalising
humanising16124973humanising
idealising1245703idealising
legalising1245743legalising
localising1345973localising
metalising1348943metalising
moralizing2249743moralizing
nasalising1145593nasalising
naturalising1354113naturalising
neutralising1374583neutralising
normalising1444973normalising
outraising1139903outra_ising
paralysing16235553paralysing
penalising1347623penalising
pluralizing2345213pluralizing
praising113214563_pra_ising
raising83220533__ra_ising
realizing19313813r_ealizing
rerising93017783rer__ising
romanising1346583romanising
ruralise839643ruralis__e
ruralised1046593ruralis_ed
ruralises939123ruralis_es
ruralism1048533ruralis__m
ruralisms1147353ruralis_ms
ruralist8311703ruralis__t
ruralists947643ruralis_ts
ruralities1048573ruralities
serialising12167003serialising
surmising1247683sur_mising
surplusing1353343surplusing
surprising1345623surprising
totalising1147313totalising
upraising1237263upra_ising
urbanising1344653urbanising
utilising1046633_utilising
vitalising1446843vitalising
vocalising1645523vocalising

Search took 7 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 Filter1786911406030.423422437.4
2DLD Change Limit140603545.75024452.7
3Display Results54540.0331636.4
 (SQL Overall)178691546.20628793.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.