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

48 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
assignee94484(None) 
assigned1044631assigned
assignees1043501assignees
assigner944851assigner
assign736782assign__
assignat945682assignat
assigners1044412assigners
assignor942992assignor
assigns836192assign_s
designee1087752designee
signee73617232__signee
soignee8279132_soignee
alienee71013153a_lienee
aligned9128553a_ligned
aligner8108313a_ligner
antigene9410203antigene
arsine64021043arsi_n_e
arsines73518813arsi_nes
assignable1343063assignable
assignats1044003assignats
assigning1144673assigning
assignment1353893assignment
assignors1043243assignors
assisted936233assisted
assister836753assister
assize1538633assi__ze
assizes1638453assi_zes
bassinet10312843bassi_net
cassine93817283cassi_n_e
cassines103116613cassi_nes
cassingle1244103cassingle
consignee1246563consignee
cosigned1235723cosigned
cosigner1135953cosigner
designed1136943designed
designees1145003designees
designer1036543designer
insigne837673insign_e
reassigned1243603reassigned
resigned1038863resigned
resigner937793resigner
signed83413753__signed
signees83510803__signees
signer74015633__signer
signet73621153__signet
soigne74310033_soign_e
unassigned1262473unassigned
unsigned1037563unsigned

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 Filter1786911461620.826216332.9
2DLD Change Limit146162486.90621164.5
3Display Results48480.0163000.0
 (SQL Overall)178691487.74823062.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.