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

68 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
filliping154423(None) 
filleting1335852filleting
filling113520802fill__ing
billeting1236643billeting
billing103823853bill__ing
billowing1545873billowing
bollixing1944813bollixing
colliding1338583colliding
disliking1537313disliking
dolloping1344993dolloping
falling113621583fall__ing
fallowing1666433fallowing
fellating1339253fellating
felling113321133fell__ing
fellowing1655923fellowing
fielding13206863fiel_ding
filching1736113fi_lching
fileting1239303fi_leting
filiating1339253filiating
filing103823763fi_l__ing
fillings122910503fill__ings
fillip11268953fillip___
filliped1435223fillip_ed
fillips12298133fillip__s
filmgoing1641713filmgoing
filming133210353fi_l_ming
filtering13199723filtering
finalising1446673finalising
finalizing2347983finalizing
finiking16277073fi_niking
flailing12298923f_lailing
flapping16298153f_lapping
flipping16307663f_lipping
fliting113514613f__liting
flopping16388773f_lopping
flumping16287583f_lumping
folioing1237573f_olioing
following1665753following
frilling123011493frill__ing
fullering1336653fullering
fulling114019703full__ing
fulmining1554403fulmining
galloping1356253galloping
gilling93520383gill__ing
gillying13306813gill_ying
hilling113821773hill__ing
hilloaing1375433hilloaing
hilloing12158303hill_oing
illuding1035803_illuding
illuming1135873_illuming
killing123118723kill__ing
lolloping1244693lolloping
milling103223683mill__ing
misliking1637113misliking
misliving1546983misliving
nilling83619563nill__ing
pillaging1345573pillaging
pillaring1237653pillaring
pilling103722563pill__ing
pillowing1545493pillowing
rilling84023623rill__ing
sliping103314413__sliping
tillering1037883tillering
tilling83522783till__ing
walloping1545593walloping
willing113821613will__ing
willowing1645323willowing
willying15306713will_ying

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 Filter1786911486410.420425454.8
2DLD Change Limit148641686.25023782.6
3Display Results68680.0332060.6
 (SQL Overall)178691686.70326658.4
 
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.