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

47 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
vanpoolings175132(None) 
vanpooling1642731vanpooling_
carpooling1545023carpooling_
spoolings12245393__spoolings
vanpools1343193vanpool___s
vaporings1544093va_p_orings
anglings10228274_an__glings
balloonings1452134balloonings
bantlings12216604ban__tlings
canoodling1443584canoodling_
canyonings1642874can_yonings
cartoonings1442664cartoonings
eanlings9128474ean___lings
gadroonings1451574gadroonings
handlings14237344han__dlings
harpooning1644484harpooning_
inpourings1342444_inpourings
lampooning1543534lampooning_
landholdings1851654landholdings
landownings1651544landownings
lanolines939984lan__olines
lanolins8310534lan__olin_s
mandolines1347104man_dolines
mandolins1248434man_dolin_s
mantlings12207234man__tlings
noonings9246654__n_oonings
panelings12107454pan__elings
panellings1344534pan_ellings
pangolins1247374pan_golin_s
pooling103219094___pooling_
respooling1355744respooling_
samplings1435554samp__lings
sanderlings1343434sanderlings
sandlings11238094san__dlings
santolinas1043754san_tolinas
saplings11269804sa_p__lings
schoolings1644014_schoolings
snooling93013474_sn_ooling_
spooling113212564__spooling_
toolings9248474___toolings
unspooling1343854unspooling_
vamoosing1543654va_moosing_
vanillins1245554van_illin_s
vanpool1243764vanpool____
vaporing1437654va_p_oring_
vapouring1544654va_pouring_
varooming1545084va_rooming_

Search took 9 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.420425454.8
2DLD Change Limit148819478.14318275.7
3Display Results47470.0301566.7
 (SQL Overall)178691478.59320794.9
 
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.