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

50 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
logrollings135121(None) 
logrolling1243061logrolling_
logrollers1142223logroll_ers
logrolls943373logroll___s
lordlings1143923lo_r_dlings
rollings9419953___rollings
trollings10286693__trollings
borrowings1642144borro_wings
carolling1259414_carolling_
controlling1445424controlling_
corallines1246554co_rallines
corbelings1544074co_rbelings
corralling1345434corralling_
drillings11285824__drillings
drolling103510764__drolling_
enrolling1087734_enrolling_
frillings13265804__frillings
godlings11367494__g_odlings
golfings13304874__g_olfings
goslings10297554__g_oslings
graylings1433884__graylings
grilling103811534__grilling_
groupings13273814__groupings
growling1348164__growling_
gruelings1163764__gruelings
gruellings1272324__gruellings
laurelling1144464laurelling_
ligroines1044994ligro__ines
ligroins946824ligro__in_s
loblollies1251394loblolli_es
loggings11398234log___gings
logroll844264logroll____
logrolled1142534logroll__ed
logroller1042444logroll__er
lolling83415774l___olling_
lordings10368504lo_r__dings
lordling1077744lo_r_dling_
lowballing1642274lowballing_
outrolling1137534outrolling_
patrolling1345694patrolling_
pogroming1544734pogro_ming_
rerolling102210374_rerolling_
rolling83620414___rolling_
scrolling12187804_scrolling_
strolling10238794_strolling_
toolings9248474to__o_lings
towellings1452894to_wellings
trolling93212494__trolling_
unrolling1078564_unrolling_
worldlings1541924wo_rldlings

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.436409841.7
2DLD Change Limit148819508.68617133.2
3Display Results50500.0163125.0
 (SQL Overall)178691509.13819554.7
 
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.